Column A contains numbers from rows 1 to 20. You can use the formula (blank) to find the value of the largest number divided by

Question

diamong [38]

3 years ago

6

Column A contains numbers from rows 1 to 20. You can use the formula (blank) to find the value of the largest number divided by

the total number of value.

Computers and Technology

2 answers:

storchak [24] · Answer 1 · 2022-07-04T00:48:31+03:00

This question can easily be answered if you have an idea about handling spreadsheet applications.

Let's say MS Excel
Column A contains numbers from rows 1 to 20. You can use the formula _______ to find the value of the largest number divided by the total number of value.

In MS Excel, the formula MAX ( ___ ) and COUNT ( ____ ) to get the value
= MAX(A1:A20) / COUNT(A1:A20)

kirill115 [55] · Answer 2 · 2022-07-04T03:10:03+03:00

Answer:

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

Explanation:

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