The _____ function calculates the average of values in a range that match criteria you specify.
A) AVERAGEAS
B) AVERAGEOR
C) AVERAGEAND
D) AVERAGEIF
Correct Answer:
Verified
Q65: Your boss in the human resources department
Q66: For conditional formatting,a formula must be in
Q70: You have been using a variety of
Q71: The _ function adds the values in
Q72: You have been using a variety of
Q73: Evaluate the formula =AND(G2="FT",M2>=1) based upon the
Q74: To change the background fill color of
Q82: Each time you create a conditional format
Q92: The COUNTIF function is sometimes referred to
Q97: In the Edit Formatting Rule dialog box
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