Page 186 - CA_165_V2.0_C9_Flipbook
P. 186
Numeric Data
Numeric Data consists of digits (0–9), exponential(^), decimal (.) and numeric operators (+,-,/,*,%,$).
Numeric data or values are aligned towards the right side in a cell. The numbers or values on which
formulae are applied to perform mathematical operations are called OPERANDS.
Alphanumeric or Text Data
Alphanumeric data are the data which are textual in nature. It refers to the data which is a combination
of alphabet, spaces, digits and/or other characters. In Calc, alphanumeric data are aligned (by default)
towards the left side of the cell and are generally not meant for calculation.
Date and Time
Calc displays date as sequential numbers known as Serial Values. Date and Time are values and therefore
can be added or subtracted and can be included for other calculations. They are aligned (by default)
towards the right side of the cell.
Formula
A formula is an expression which helps to perform arithmetical calculation and also executes non-
arithmetical tasks. It consists of the operands and the operators which operate upon the data. A formula
always starts with an ‘=’ sign.
CREATING A SPREADSHEET
To work in Calc, the user needs to know how to work with Spreadsheet. Calc opens with a new
Spreadsheet named Untitled1 as the default spreadsheet where the user can begin to work.
A user can also create a new spreadsheet using the following steps:
Step 1: Click on the File menu from Menu bar.
Step 2: Select the New option. A drop-down menu appears.
Step 3: Click on Spreadsheet.
OR
Click on the New button from the Standard Toolbar. A new spreadsheet named Untitled 1
appears on the screen.
1
3
2
184 Touchpad Computer Applications (Ver. 2.0)-IX

