Page 31 - Viva ICSE Computer Studies 8 : E-book

Average ( )
The Average function returns the average of the
range values.
Step 2
Follow these steps to use the Average function.
1. Click on the cell A7 where you want to Step 3
display the average of values. Step 4
2. Click on the AutoSum option in the ‘Editing’
Step 1
group of the ‘Home’ tab.

3. Select the Average function from the drop-down list.
4. A dashed border will appear around A1 through A6 and Excel automatically enters the
formula in ‘A7’. Press the Enter key to get the result.

Learn More

You can also type = sign, followed by the name of the function AVERAGE. Put the parenthesis symbol
and select the cell to defi ne the range of the cells.

Max ( )

The Max function returns the largest value in the given range.

Follow these steps to use the Max function.
1. Click on the cell A7 where you want to display the result.
2. Click on the AutoSum option in the
‘Editing’ group of the ‘Home’ tab.

3. Select the Max option from the drop-
Step 2
down list.
4. A dashed border will appear around A1
through A6 and Excel will automatically
Step 3
Step 4 enter the formula in ‘cell A7’. Now press
the Enter key to get the result.

Min ( )
The Min function returns the smallest value in
the given range.
Step 2
Follow these steps to use the Min function.
1. Click on the cell A7 where you want to
display the result. Step 3
Step 4
2. Click on the AutoSum option in the
‘Editing ’group of the ‘Home’ tab.
3. Select the Min function from the drop-down list.
4. A dashed border will appear around A1 through A6 and Excel will automatically enter
the formula in ‘cell A7’. Now press the Enter key to get the result.

19