MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A comparison operator
A)NOW
B)error value
C)COUNTA
D)

Question

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A comparison operator
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

The comparison operator "<" is used to check if one value is less than another value.

Answer: E
 MEDIAN is a function used to find the middle value in a set of numbers.

Answer: F
 These are the names of the weekdays in chronological order.

Answer: G
 F4 is a keyboard shortcut used to repeat the last action in Excel.

Answer: H
 Absolute refers to a cell reference that does not change when a formula is copied or moved to a new cell.

Answer: I
 Nested refers to a formula or function that is used inside another formula or function.

Answer: J
 Mixed refers to a cell reference that contains both relative and absolute references, such as $A1.

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