Which function in Excel is used to find the highest value in a range of cells?

a) MAX

b) SUM

c) AVERAGE

d) COUNT

Show Answer

a) MAX

To find the highest value in a range of cells in Excel, you can use the MAX function. The MAX function returns the maximum (highest) value in a given set of values or a range of cells. Here’s how you can use it:

  1. Select a cell where you want the highest value to appear.
  2. Type the formula using the MAX function, followed by an open parenthesis “(“.
  3. Select the range of cells or enter the cell references you want to find the maximum value from.
  4. Close the parenthesis “)” and press Enter.

For example, if you want to find the highest value in cells A1 through A10, you would use the formula like this: = MAX(A1:A10). Excel will then display the highest value in that range.