Multiple Choice
Match the following terms with their description:
i. Formula AutoComplete
II. Quick Analysis
III. Function ScreenTip
IV. Logical test
v. Syntax
A) Can be used to apply formatting and insert basic functions
B) Pop-up description
C) A set of rules
D) Matches letters as you type
E) Evaluates to True or False
Correct Answer:

Verified
Correct Answer:
Verified
Q12: _ references change when formulas are copy
Q22: The _ function is similar to the
Q39: The two optional arguments in the PMT
Q44: Using _ simplifies adding complex mathematical formulas
Q60: If the annual interest rate is 12%
Q64: Match the following terms with their description:<br>i.
Q67: The HLOOKUP function can only be used
Q81: If the cell reference $A5 in a
Q87: Where does Excel automatically display statistics like
Q96: A function's _ defines the rules by