Page 267 - open office
P. 267
On the right side, the corresponding in-built function is displayed. E.g.:SUM ( umber1 umber2 ....)
Step 3: Select the ‘Category’ as ‘Mathematical’ from the list box.
Step 4: Select the SUM function.
Step 5: Click on ‘Next’.
Step 6: Fill the range of cells to be calculated in the given text box. (Here, range of cells is given as (B2:F2)).
3
6
4
5
7
Step 7: Click on the OK button of the function wizard. The result will be displayed in the cell 2.
Sneak Peek
To use functions is MS Excel:
1. Select the cell in which the output has to be displayed or function is to be inserted. Here,
cell G2 has been selected to enter the function.
2. Click on the fx button on the Formula bar. ‘=’ sign will appear in the Formula bar. The Insert
Function dialog box will also appear on the screen.
3. Click on the drop-down arrow of or select a category drop-down list.
4. Click on Math & Trig option from the list.
5. Search and click on the SUM function from the Select a function list.
6. Click on the OK button. The Function Arguments dialog box will appear on the screen.
. Enter the range of cells to be calculated in the umber1 text box. Here, the range of cells is
given as B2:F2.
. Click on the OK button. The result will be displayed in the cell 2.
COMMON ERRORS
Sometimes when we use wrong type of data, operand or operator in a formula, an error message is displayed.
Given below is the list of errors which commonly occurs in ‘Calc’.
Working with Spreadsheet 26

