MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to cycle through reference types
A)NOW
B)error value
C)COUNTA
D)

Question

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to cycle through reference types
A)NOW
B)error value
C)COUNTA
D)<
E)MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed

Quizplus · Accepted Answer

F4 is the keyboard shortcut in Excel used to cycle through the reference types (such as absolute, relative, or mixed references).

Answer: J
 Mixed references refer to a combination of absolute and relative references in a single cell reference.

Note: The other options listed are not related to cycling through reference types.

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