Multiple Choice
The ________ functions provide added flexibility of multiple data ranges that can be located throughout an Excel spreadsheet.
A) SUM and AVERAGE
B) VLOOKUP and HLOOKUP
C) IF and COUNTIF
D) MATCH and INDEX
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q17: The _ argument of the COUNTIF function
Q18: The NEVER function allows creation of logical
Q19: The _ function is used when the
Q20: The first argument of the AVERAGEIFS function
Q21: The _ function looks for a value
Q23: If letters appear for the column headings,the
Q24: Data that is manually calculated is known
Q25: All of the following statements are TRUE
Q26: Which of the following is NOT an
Q27: The IF function can employ other logical