Page 199 - CA 165 ver 1.0 Class 9
P. 199
Consider a worksheet that has the following details:
A B C D E
1 Name_of_Sales_Man Sale_in_2015 Sale_in_2016 Sale_in_2017 Total_Sale
2 Kumar Narayan 80000 80000 99000 259000
In the address bar assign the cell A1 as Name_of_Sales_Man, B1 as Sale_in_2015, C1 as Sale_in_2016, D1
as Sale_in_2017 and E1 as Total_Sale. Enter the value in the cell A2, B2, C2 and D2 as Kumar Narayan,
80000, 80000, 99000 respectively.
Now enter a formula in cell E2, say = B2 + C2 + D2
After pressing the Enter key, the output would get displayed as 259000 in cell E2.
Formula With In-Built Functions
Functions are in-built formula in ‘Calc’, which can be used to perform arithmetical and non-arithmetical
tasks. In ‘Calc’ there are more than 375 in-built functions which can be applied directly or as part of
a formula. For Example: A formula, say =A1+A2+A3+A4+A5 can be written using the ‘SUM’ function
along with cell range as: =SUM(A1:A5).
A function contains ‘Name’ and ‘Argument’.
=SUM(A1:A5)
Name Argument
‘Name’ is the function that signifies the nature of operation. ‘Argument’ specifies the values or the range
of cells on which the specific operation is being applied and is always enclosed within the opening and
closing parenthesis (i.e., Name refers to the operator and Argument refers to the operand).
Notes
To apply a function on selected cells or on a range of cells, a semicolon (;) is used, i.e. for denoting
two cells A1 and A2, ‘A1;A2’ is applied.
CELL REFERENCING
The identification or address of a cell in a formula is known as a ‘Cell Reference’. There are three types
of referencing in ‘Calc’.
l Relative Referencing l Absolute Referencing
l Mixed Referencing
Relative Referencing
It is based on the position of the cell in which the formula is typed with respect to the cell address of the
formula. When we copy or move the formula to other cells, the reference (cell address) automatically
changes according to the relative position of cells in consideration.
Data Analysis 197

