Question

If A1 :A5 contain the numbers 16 10 3 25 and 6 then =average (A1:A5;60) will display

Answer 1

Answer:

=average (A1:A5;60) = 20

Explanation:

Given:

A1 = 16

A2 = 10

A3 = 3

A4 = 25

A5 = 6

To find:

=average (A1:A5;60)

Solution:

The cells from A1 to A5 contain the given numbers as mentioned above. In order to find the average of these numbers and add 60 to it, we use the following function in Excel: =average (A1:A5;60)

By doing so we get the following answer: =average (A1:A5;60) = 20

We can also cross check the same, manually by taking the average of the 5 values and add 60 to it.

Therefore, average => (16 + 10 + 3 + 25 + 6 + 60) / 6 = 120 / 2

Therefore, average or =average (A1:A5;60) = 20

#SPJ1

Answer 2

Explanation:

(16 + 10+3+25+6+60)/6

120/6

20