The ________ Functions Provide Added Flexibility of Multiple Data Ranges

question 22

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

---

Definitions:

Executive

A high-level manager or administrator in an organization who is responsible for making major decisions and managing operations.

Managerial

Pertaining to the activities, responsibilities, or characteristics of management or managers within an organization.

Wage Surveys

Systematic processes for collecting data about compensation rates for specific jobs within an industry, region, or organizational level to establish competitive and fair wage structures.

Salary Surveys

Research tools used to determine the average compensation paid to employees in specific job categories, industries, or geographic areas.