Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-You can calculate the number of cells in a range that match criteria you specify using this function
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
Q3: The _ error value appears when text
Q16: Case-Based Critical Thinking Questions<br>Case 7-1<br>Evaluate the following
Q17: To change the duplicate values background fill
Q18: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -According to the
Q20: Even if the compare values are not
Q26: The table that stores the data you
Q71: What are the guidelines to keep in
Q84: You have been using a variety of
Q91: A(n)_ specifies the type of condition the
Q105: The _ function calculates the difference between