Page 174 - CA 165 ver 1.0 Class 9
P. 174
Numeric Data
‘Numeric Data’ consists of digits (0–9), ‘e’ (Exponential), decimal (.) and numeric operators like +,-
,/,*,%,$. 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. Alphanumeric data is mentioned within double
quotes “ ”. 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. The time is displayed as fractional
part (it is considered as a part of a day). 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 WORKBOOK
To work in ‘Calc’, the user needs to know how to work with a Workbook. ‘Calc’ opens with a new
workbook named ‘Untitled 1’ as the default workbook where the user can begin to work.
A user can also create a new workbook using the following steps:
Step 1: Click on the ‘File’ menu and click on the ‘New’ option.
Step 2: A sub-menu appears, click on ‘Spreadsheet’.
OR Click on the ‘New’ button from the Standard Toolbar.
Active Cell
A new workbook displaying the active worksheet, ‘Sheet1’ appears on the screen with cell A1 as the
active cell.
172 Touchpad Computer Applications-IX

