MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A date and time function
A)NOW
B)error value
C)COUNTA
D)

Question

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A date and time function
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

NOW is a date and time function that returns the current date and time.

Answer: H
 Absolute refers to a reference in a formula that always stays the same, regardless of where the formula is copied.

Answer: G
 F4 is a keyboard shortcut that allows you to toggle between absolute and relative reference in a formula.

Answer: I
 Nested refers to a formula within another formula.

Answer: F
 Mon, Tues, Wed, Thurs, Fri are the abbreviations for weekdays in a calendar.

Answer: E
 MEDIAN is a statistical function that returns the middle value in a range of numbers.

Answer: C
 COUNTA is a function that counts the number of non-blank cells in a range.

Answer: D
 < is a comparison operator that checks if a value is less than another value.

Answer: J
 Mixed refers to a cell reference that combines absolute and relative references, such as $A1 or A$1.

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