Question

which of the following functions returns the highest value in a range of cells?
○ min
○ max
○ sum
○ total

Explanation:

• The MIN function returns the lowest value in a range.
• The MAX function is designed to return the highest value in a range of cells.
• The SUM function calculates the sum of values in a range.
• The TOTAL function (not a standard function for this purpose in typical spreadsheet software; SUM is used for totaling) does not return the highest value.

Answer:

B. MAX