Match the example with the function or feature:
I. =A54
II. =$A54
III. =$A$54
IV. =SUM(A54:B97)
V. "Ohio"
A. Function
B. Relative reference
C. Ensures text entry
D. Mixed reference
E. Absolute reference
Correct Answer:
Verified
Q49: The _ feature in Excel displays various
Q74: A good practice when entering function names
Q77: The COUNTBLANK function will count cells that
Q79: The COUNTA function only counts text entries.It
Q82: Match the example with the function or
Q82: The two optional arguments in the PMT
Q83: The HLOOKUP function can only be used
Q86: Match the following terms with their description:
I.
Q87: If you are looking up exact values
Q88: A lookup table should contain at least
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents