Page 19 - Trackpad_V1_Book 7_Flipbook
P. 19
In the previous class, we have learned that Excel is a spreadsheet software used to work with
numbers, text, formulae and charts. Excel is used when there is a need to handle large sets of
data that require various calculations and in-depth analysis. Since we have already learned how
to work with formulae and functions present in the application. Let’s recall some functions & also
learn some more useful features of Excel.
SUM()
The SUM() function calculates the total of a given set of values. To use the SUM() function, follow
the given steps:
2 Click on the Formulas tab.
3 Click on Insert
Function option.
1 Select
the cell.
5 Click on Or select a category option
and select the Math & Trig option. 7 To calculate the average of numbers
in cells C2 to H2, the range must be
specified as C2:H2 in the Number1 box.
4 Select SUM function.
6 Click OK button. 8 Click OK button.
Advanced Features of Excel 17

