MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.
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

This is referring to named ranges or cells, which have a global scope and can be referenced throughout the workbook.

Answer: A
 Hiding refers to hiding columns, rows or worksheets in Excel.

Answer: B
 Periods and underscore characters are commonly used in Excel for naming ranges or cells.

Answer: D
 PMT stands for Payment and is a financial function in Excel used to calculate the periodic payment for a loan.

Answer: E
 PV stands for Present Value and is a financial function in Excel used to calculate the present value of an investment.

Answer: F
 A two-input data table is a feature in Excel used for sensitivity analysis, where users can vary two inputs to see how they affect a calculated result.

Answer: G
 ROUND is a function in Excel used for rounding numbers to a specified number of digits.

Answer: H
 The Draft quality check box is a setting in Excel used for printing, which prints documents in a lower quality to save ink or toner.

Answer: I
 The formula checker is a feature in Excel used to check for errors or inconsistencies in formulas.

Answer: J
 Background formula checking is a setting in Excel that automatically checks for errors in formulas as users input data.

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