Minimum temperatures are given in cells D2 to d5 so what does Anu have to type to find out their average
Answers
Given : Minimum temperatures are given in cells D2 to D5
To Find : average in MS excel
Solution:
MS excel has spread sheet
in form of column and row
D2 , D5 are cells
D2 Means Column D and row 2
D5 Means Column D and row 5
Minimum temperatures are given in cells D2 to D5
Hence in D2 , D3 , D4 , D5
In Excel there are inbuilt functions.
She has to use function AVERAGE
She has to write :
=AVERAGE(D2:D5)
This will add all the values from D2 to D5 and divided by the number of values from D2 to D5
Another way to write is
=AVERAGE(D2,D3,D4,D5)
This is generally used when cells are not continuous
This will be tedious if cells are in larger numbers like from D2 to D100
Then u have to typo so many cells
in 1st method just D2:D100 will work
Learn More:
Difference between sorting and filtering in excel - Brainly.in
brainly.in/question/8773232
Which of these charts does not exist in MS Excel. *1 point(a). Scatter ...
brainly.in/question/33686516