MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Can be used to determine the monthly payment for a loan.
A)hiding
B)periods and underscore characters
C)global
D)PMT
E)PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question

Quizplus · Accepted Answer

PMT (Payment) function is used to determine the monthly payment for a loan.

Answer: E
 PV (Present Value) function calculates the present value of an investment.

Answer: F
 A two-input data table is used to see how different combinations of two sets of data will affect the results of a formula.

Answer: G
 ROUND function is used to round a number to a specified number of digits.

Answer: I
 Formula checker searches for errors in formulas.

Answer: J
 Background formula checking allows Excel to continuously check for errors in formulas as the user types.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase