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
4.1k points

2 Answers

3 votes

Answer:

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

Step-by-step explanation:

User Frattaro
by
4.3k 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
4.2k points