Question

Activity Card Information &
Class: 9
Communications Technology
Now, can you help Anu in doing the following activities
1. Maximum temperatures are given in cells C2 to C5. So, what does Anu
have to type to find out their average?​

Answer 1

Answer:

=C2+C5/2

I hope this will help you

Answer 2

Given : Maximum 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

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