Question

Maximum temperatures are given in cells C2 to C5.So,what does Any have to type to find out their average?

Answer 1

Answer:

aximum temperatures are given in cells C2 to C5

To Find :   average in MS excel

Solution:

MS excel has spread sheet

in form of column and row

C2 , C5 are cells

C2  Means  Column C and row 2

C5 Means  Column C and row 5

Minimum temperatures are given in cells C2 to C5

Hence in C2 , C3 , C4 , C5

In Excel there are inbuilt functions.

She has to use function AVERAGE

She has to write :

=AVERAGE(C2:C5)

This will add all the values from C2 to C5 and divided by the number of values from C2 to C5

Another way to write is

=AVERAGE(C2,C3,C4,C5)

This is generally used when cells are not continuous

This will be tedious if cells are in larger numbers like from C2 to C100

Then u have to typo so many cells

in 1st method just C2:C100 will work