Solved

The ____ Function Calculates the Average of Values in a Range

Question 42

Multiple Choice

The ____ function calculates the average of values in a range that match criteria you specify,such as calculating the average salary paid to employees in each city.


A) AVERAGEAS
B) AVERAGEOR
C) AVERAGEAND
D) AVERAGEIF

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q38: To highlight duplicate values,in the Styles group

Q38: You can include up to _ logical

Q39: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -Given the flowchart

Q39: You cannot nest more than one IF

Q44: If you use a structured reference outside

Q55: MATCHING<br>Identify the letter of the choice that

Q79: A formula that includes a structured reference

Q109: If you need to modify the formula

Q113: All the logical conditions listed in an

Q114: The _ error value means that the