Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to reference cells within an Excel table
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) calculated column
F) AVERAGE
G) HLOOKUP
H) COUNT
I) logical condition
J) SUM
K) AVERAGEIF
L) cell and range addresses
Correct Answer:

Verified
Correct Answer:
Verified
Q4: Calculated columns work only in ranges of
Q6: When Excel automatically fills the rest of
Q39: For conditional formatting,a formula must be in
Q46: A(n)_ function is when one IF function
Q55: Press the _ keys to move to
Q56: The _ error value means that invalid
Q63: MATCHING<br>Identify the letter of the choice that
Q63: When using VLOOKUP,the _argument is optional.<br>A)lookup_value<br>B)table_array<br>C)range_lookup<br>D)col_index
Q69: The _ function is a logical function
Q86: The categories for a lookup table called