Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Excel table column containing data derived from other columns
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
Q46: A(n)_ function is when one IF function
Q55: Press the _ keys to move to
Q56: The _ error value means that invalid
Q57: The major difference between HLOOKUP and VLOOKUP
Q58: _ formatting changes a cell's formatting when
Q59: MATCHING<br>Identify the letter of the choice that
Q60: For the col_index_num value,be sure to enter
Q67: MATCHING<br>Identify the letter of the choice that