Page 272 - Trackpad IT-402_Class-IX
P. 272
Step 3: Press the ENTER key on the keyboard or click on another cell using the mouse.
TYPES OF DATA
The data entered in a cell can be:
• Label/Text: Any set of characters like letters, numbers or special characters that can be entered in a cell is called a
Label. Labels in a cell are always left-aligned by default.
• Value/Number: The numbers like salary, marks, etc. that can be entered in a cell are called value. Values in a cell
are always right-aligned. If you enter a number preceded by zero, then it is ignored and only the number will be
displayed.
• Formula: An expression that begins with an “=” sign is called a formula in a spreadsheet. It can have a value, cell
address or function. The equal sign indicates that the following part after the equal sign is a formula and not just a
name or number. A formula can be directly entered in a cell or by typing it in an Input line of the formula bar.
An expression without an equals “=” sign is treated as text and no calculations will be done. For example, A1+B1+10
will not give any answer because it is not preceded by an “=” sign.
Mathematical Operators Used in a Formula
The mathematical operators that can be used in a formula for calculations in a spreadsheet are:
Mathematical Operators Example Result
+ Addition =10+2 12
- Subtraction =10-2 8
* Multiplication =10*2 20
/ Division =10/2 5
^ Exponential (Power) =10^2 100
When multiple operators are used in an expression, the operators are evaluated in the order of precedence as
given below:
272 Trackpad Information Technology-IX

