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

Question

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-References that are fixed
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

"Absolute" refers to cell references that do not change when a formula is copied to other cells.

Answer: A
 "NOW" is a function in Excel that returns the current date and time.

Answer: J
 "Mixed" cell references refer to a combination of absolute and relative references (e.g., $A1 or B$1).

Answer: F
 "Mon, Tues, Wed, Thurs, Fri" refers to the days of the week, and is not an Excel function or term.

Answer: B
 "Error value" refers to a message that appears in a cell when a formula is entered incorrectly or is unable to calculate a value.

Answer: E
 "Median" is a function in Excel that returns the middle value in a range of cells.

Answer: G
 "F4" is a keyboard shortcut in Excel that repeats the last command or action performed.

Answer: C
 "COUNTA" is a function in Excel that counts the number of cells in a range that are not empty.

Answer: D
 "<" is a symbol in Excel used to compare two values and determine if one is less than the other.

Answer: I
 "Nested" functions in Excel refer to using one function as an argument for another function.

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