Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to calculate the average of values in a range that meet criteria you specify
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
Q30: The _ error value occurs when an
Q55: Case-Based Critical Thinking Questions<br>Case 7-1<br>Evaluate the following
Q55: Press the _ keys to move to
Q57: The major difference between HLOOKUP and VLOOKUP
Q58: _ formatting changes a cell's formatting when
Q60: For the col_index_num value,be sure to enter
Q63: MATCHING<br>Identify the letter of the choice that
Q67: When you create a formula that references
Q131: When you retrieve a particular value from