Page 88 - IT-802_class_12
P. 88
Now to find the Total_Sale in cell E2, enter the formula = S2019 + S2020 + S2021. After pressing the Enter key, the
output will be shown as 260000 in cell E2.
3.10 fUNCTIONS
Functions are in-built formulas in ‘Calc’ that can be used to perform arithmetic and non-arithmetic tasks. In ‘Calc’, there
are more than 375 in-built functions that can be applied directly or as part of a formula. A function contains ‘Name’ and
‘Argument’.
For example, a formula like A6=A1+A2+A3+A4+A5 can be written using the ‘SUM’ function along with a cell range as:
A6=SUM(A1:A5)
Functions are entered into cells to produce the calculated output of data. Calc has a set of predefined formulas
called Functions. A formula contains both operands and the operator; however, functions only contain operands (or
arguments), as functions perform a predefined operation on the arguments.
To enter a function in a cell:
1 Select the cell in which the output has to be displayed or a function is to be inserted (For example, in a worksheet,
cell G2 has been selected to enter the function.)
2 Select the option Function from the Insert menu.
OR
Click on the ‘fx’ button from the Formula Bar.
A ‘=’ sign will appear in the Formula bar and the Functions Wizard will open.
On the left side in the wizard, different types of categories for types of data, calculations, or analysis are displayed, like:
Database, Date and Time, Financial, Logical, Mathematical, Statistical, Text, etc.
On the right-hand side, the corresponding in-built function is displayed. For example, =SUM (Number1, Number2,....)
Fill in the range of cells to be calculated in the given text box.
(Say, here the range of cells is (B2:F2).
86 Touchpad Information Technology-XII

