MIS Test 3 Flashcards
To calculate the present value of a loan or an investment use the?
PV Function
What function is used to calculate the amount of a payment used to pay the interest on a loan?
IPMT
What function is used to calculate the interest on a loan or an investment?
RATE
___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.
goal seek, input value
T/F. Referencing data in other workbooks creates a link between the workbooks
True
What are the functions of an IF function?
Returns one value if the condition is true & returns one value if the condition is false
Calculating an investment’s length with the NPER function
Returns the number of payment periods
What type of depreciation depreciates assets by equal amounts each year of its lifetime until it reaches the salvage value?
Straight-line
Functions that can determine if a cell contains an error value and then display the message you choose rather than the default error value.
INFERROR function
A rule that specifies the condition, the formatting, and the cell or range to apply the rule to.
Conditional formatting rule
Worksheets that are grouped must have the same ___ & ___.
Rows, columns
The ____ function tests two or more conditions and determines whether all conditions are true.
AND
T/F E-business is a major factor in the widespread use of global information systems.
True
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.
True
Describe what happens in Phase 1: Planning?
In phase 1 the issue that the company is facing is define. It mainly focused on the problem.
T/F A cost-effectiveness analysis is based on the concept that one dollar today is worth more than one dollar from the past.
False (not past, but future)
T/F Internal users are not employees who sue the information system, including customers and suppliers.
False (external users
Which of the following is prototyping NOT used for?
Sold as the final version of a product
A CRM system includes all of the following:
Sales Automation, Order Processing, Customer Supportt