Which Excel function averages cells in a range based on a specified condition?
A) AVERAGEIF
B) AVERAGE
C) COUNTIF
D) SUMIF
Correct Answer:
Verified
Q16: The AND function returns a value of
Q17: One way to check worksheet formulas for
Q18: If there are invalid cell references in
Q19: The CONCATENATE function breaks a text string
Q20: Cell and range names can use uppercase
Q22: The _ refers to where you will
Q23: Which of the following is not a
Q24: Which error code will display if a
Q25: Names of cells and ranges cannot use
Q26: The CONCATENATE function joins two or more
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