The ____ function calculates the highest value found in its list of cell references.
A) COUNTA
B) SUM
C) MAX
D) HIGHEST

Name: The ____ function calculates the highest value found in its list of cell references. A) COUNTA B) SUM C) MAX D) HIGHEST
Brand: Quizplus
Rating: 4.9 (28 reviews)

Question

Quizplus · Accepted Answer

The MAX function is specifically designed to calculate the highest value in a range of cells. COUNTA counts the number of non-empty cells in a range, and SUM adds up the values in a range. HIGHEST is not a valid function in Excel.

The ____ Function Calculates the Highest Value Found in Its