Question

Type the correct answer in the box.

Fill in the correct formula.
to find the value of the largest number divided by the total number of
Column A contains numbers from rows 1 to 20. You can use the formula
values.

Answer 1

Using Excel formulas

=LARGE(A1:A20, 1)/COUNT (A1:A20)

Count (Ai:An) Function that allows to count the total number of values in a cells range between Ai and An that contain only numbers.

Large (Ai:An, k) Function that allows to find the value of the largest number in a cells range between Ai and An, the number k determine the k-th largest value