99.8k views
1 vote
Correct the function used in cell A6 to display the largest value in the numattending column.

Option 1: =MAX(numattending)
Option 2: =LARGE(numattending,1)
Option 3: =SUM(numattending)
Option 4: =AVERAGE(numattending)

User Emoun
by
7.4k points

1 Answer

2 votes

Final answer:

The correct function to display the largest value in the numattending column is =MAX(numattending).

Step-by-step explanation:

The correct function to display the largest value in the numattending column is =MAX(numattending).

The MAX function returns the largest value in a range of cells.

In this case, it will return the largest value in the numattending column.

Option 1: =MAX(numattending)

Option 2: =LARGE(numattending,1)

Option 3: =SUM(numattending)

Option 4: =AVERAGE(numattending)

User Bob Bill
by
7.9k points