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:
Verified
Q66: For conditional formatting,a formula must be in
Q77: You can edit existing conditional formatting rules
Q78: You can edit existing conditional formatting _
Q92: The COUNTIF function is sometimes referred to
Q96: In the Styles group on the Home
Q104: Case-Based Critical Thinking Questions
Case 7-1
Evaluate the following
Q105: Case-Based Critical Thinking Questions
Case 7-1
Evaluate the following
Q109: You can filter a table by color.Display
Q111: The _ function calculates the number of
Q113: To change the duplicate values background fill
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents