MIS Test 3

Question 1

To calculate the present value of a loan or an investment use the?

Answer 1

PV Function

Question 2

What function is used to calculate the amount of a payment used to pay the interest on a loan?

Answer 2

IPMT

Question 3

What function is used to calculate the interest on a loan or an investment?

Answer 3

RATE

Question 4

___automates the trial-and-error process by allowing you to specify a value for a calculated item, and then Excel returns the ___ needed to reach that goal.

Answer 4

goal seek, input value

Question 5

T/F. Referencing data in other workbooks creates a link between the workbooks

Answer 5

True

Question 6

What are the functions of an IF function?

Answer 6

Returns one value if the condition is true & returns one value if the condition is false

Question 7

Calculating an investment’s length with the NPER function

Answer 7

Returns the number of payment periods

Question 8

What type of depreciation depreciates assets by equal amounts each year of its lifetime until it reaches the salvage value?

Answer 8

Straight-line

Question 9

Functions that can determine if a cell contains an error value and then display the message you choose rather than the default error value.

Answer 9

INFERROR function

Question 10

A rule that specifies the condition, the formatting, and the cell or range to apply the rule to.

Answer 10

Conditional formatting rule

Question 11

Worksheets that are grouped must have the same ___ & ___.

Answer 11

Rows, columns

Question 12

The ____ function tests two or more conditions and determines whether all conditions are true.

Answer 12

AND

Question 13

T/F E-business is a major factor in the widespread use of global information systems.

Answer 13

True

Question 14

T/F Case-based reasoning is a problem-solving technique that matches a new casee with preciously solved case and tis solution, both stored in a database.

Answer 14

True

Question 15

Describe what happens in Phase 1: Planning?

Answer 15

In phase 1 the issue that the company is facing is define. It mainly focused on the problem.

Question 16

T/F A cost-effectiveness analysis is based on the concept that one dollar today is worth more than one dollar from the past.

Answer 16

False (not past, but future)

Question 17

T/F Internal users are not employees who sue the information system, including customers and suppliers.

Answer 17

False (external users

Question 18

Which of the following is prototyping NOT used for?

Answer 18

Sold as the final version of a product

Question 19

A CRM system includes all of the following:

Answer 19

Sales Automation, Order Processing, Customer Supportt

Question 20

T/F Executive Information Systems are interactive information systems that give executives easy access to only internal data.

Answer 20

False

Question 21

T/F An intelligent system is a machine with an embedded, Internet-connected computer that has the capacity to gather and analyze data and communicate with other systems.

Answer 21

False

Question 22

Optimal supply chains ___ disruptions and volatility.

Answer 22

anticipate, control, and react to

Question 23

T/F Artificial Intelligence is a push towards a replica of people in all respects

Answer 23

True

Question 24

Under the systems development life cycle, which phase uses the four ws?

Answer 24

Planning

Question 25

Intelligent agents are becoming more popular in ___.

Answer 25

e-commerce

Question 26

What is feasibility analysis?

Answer 26

A continuous measure of how beneficial or practical an information system will be to an organization.

Question 27

What does ERP stand for?

Answer 27

Enterprise Resource Planning

Question 28

DSS is an abbreviation for?

Answer 28

Decision Support System

Question 29

What are the 4 key decisions in Supply Chain Management?

Answer 29

Location, Inventory, Production, and Transportation

Question 30

Citibank: The new CRM provided a comprehensive yet granular security solution which solved which of Citibank's prior issues?

Answer 30

Some sensitive data lacked adequate security while other data was overprotected

Question 31

T/F Coca-Cola Enterprise: Coca Cola Enterprise never acknowledged that their communication platforms were no longer enabling innovation.

Answer 31

False

Question 32

Menchie's : What are some key issues found in the Menchie's case study?

Answer 32

Francisee's used personal email accounts & the server's IP address was often blacklisted.

Question 33

According to the Coca Coal Enterprises case study, the company had relied largely on ___ based communications for years.

Answer 33

E-mail

Question 34

Similarly to the Coca-Cola case study, what type of unreliable communication method was being used by Menchie's Frozen Yogurt?

Answer 34

E-mail

Question 35

When Menchies employees had their email accounts compromised, what was often blacklisted?

Answer 35

IP Address

Question 36

What was the negative aspect of Citi's CRM system the wealth management advisers were using?

Answer 36

The system provided only a partial view of their client's financial information.

Question 37

What did the new CRM solution provide Citibank?

Answer 37

A central 'dashboard' of key client data, a comprehensive yet granular security, & a salesforce.com mobile CRM solution that gave advisors secure access to client data.

Question 38

T/F SAP HANA simplifies IT operations and implementations.

Answer 38

True

Question 39

What does Xiaoyu Liu, the VP of Lenovo, say SAP HANA will solve in terms of their day-to-day business operations?

Answer 39

SAP HANA will help provide real-time data for business decisions.

Question 40

What are the four qualities of empathy according to the animated RSA short?

Answer 40

Perspective-taking & Staying out of judgement

Question 41

Which is NOT a benefit the company experience after implementing a tailored salesforce.com CRM?

Answer 41

Decrease in need for security of client information.

Question 42

Who spent 2 years of his life building the user experience team for the Google X division of Google?

Answer 42

Tom Chi

Question 43

What is the Prototyping Rule #1?

Answer 43

Find the quickest path to experience

Question 44

Shell KMS: What allows Shell to manage valuable data passed through valuable assets?

Answer 44

IBM Rational Asset Manager

Question 45

What did Coca-Cola Enterprises use to solve their key business challenges?

Answer 45

Microsoft online Services Technologies

Question 46

Informal Introductions

Answer 46

Hey there!, What's up?, Hi Dude

Question 47

T/F Forni believes that the reason why civility has suffered throughout the years is because people have now made themselves the central concern.

Answer 47

True

Question 48

An important civility lessons we want to impress upon the next generation is that the way we treat animals is a/an

Answer 48

measure of our self-worth

Question 49

The main difference between empathy in relation to sympathy is?

Answer 49

Empathy fuels connections