216k views
5 votes
Type the correct answer in the box.

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

User Parhum
by
8.1k points

2 Answers

3 votes

Answer:

MAX(A1:A99)/COUNT(A1:A99)

Step-by-step explanation:

User Frattaro
by
8.5k points
5 votes

Answer:

=MAX(A1:A20)

Step-by-step explanation:

The question clearly explains that we have 20 numbers stored in column A from A1 to A20. Hence our range is A1: A20, and we are required to find the largest number out of these 20. The solution seems to be straight forward. You need to type = in any cell where you want to show the largest number. Now select the MAX from the drop-down, and enter the range A1: A20 inside the parenthesis. Thus, we get the formula =MAX(A1: A20), which is what we need. As the formula will be completed, and we press enter, the largest number will be printed in that cell.

User Tanktalus
by
8.0k points

No related questions found