Page 19 - Chinmaya_C7_flipbook
P. 19
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 & 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 Click on Or select a category option
and select the Math & Trig option. 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 17

