Page 21 - trackpad v5.1 class 7 flipbook
P. 21
In the previous class, we 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 and 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 the Insert
Function command.
1 Select
the cell.
4 Select the Math & Trig option from the
Or select a category drop-down list. 7 To calculate the sum of numbers
in cells C2 to H2, the range must be
specified as C2:H2 in the Number1 box.
5 Select the SUM function.
6 Click on the OK button. 8 Click on the OK button.
Advanced Features of Excel 19

