Page 213 - CA_165_V2.0_C9_Flipbook
P. 213
For naming a cell, click on the cell and type the name for that cell in the name box, and press Enter key.
Name can be used directly in a formula.
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
Data Analysis 211

