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

Question

Quizplus · Accepted Answer

MATCH and INDEX functions allow you to locate and retrieve data from multiple ranges across a spreadsheet, offering flexibility in data management.

The ________ Functions Provide Added Flexibility of Multiple Data Ranges