Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q26: You can scale a worksheet so that
Q27: To use a name that consists of
Q28: If you wish to allow another worksheet
Q29: When a formula fails to pass one
Q30: A name cannot be assigned to two
Q32: You should _ all other cells (non
Q33: _ portions of a workbook lets you
Q34: The arguments in _ in the ScreenTip
Q35: To prevent round-off errors,use the _ function.<br>A)
Q36: Ruth has a home office that she