Page 304 - TP_IT_V1.0_C9_flipbpookl
P. 304
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. It can be in
decimals also. 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. To show the preceding ‘0’, the data type has to be specified as ‘Text’.
• 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. The advantage of using a formula is that if a number
in a cell used as a cell reference in a formula changes then the result is automatically updated.
uiz Bee If A1 has value 10 and B1 has Value 20 then write the given formula in cell C1 as =A1+B1.
The Answer displayed in cell C1 will be 30. Now go to cell A1 and change the value 10 to
20. What will happen to the value in Cell C1?
MATHEMATICAL OPERATORS USED IN A FORMULA
The mathematical operators that can be used in a formula for calculations in a spreadsheet are:
+ 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:
Order of precedence Operator
1 ()
2 ^
3 / *
4 + –
In the above order of precedence, / and * are in the same order. Similarly, + and - are in the same order. In an
expression, if the operators of the same order are present, then the order of evaluation of the expression will be from
left to right. Let's see some examples given below:
Formula Evaluation Result
=5–4/2
=2+3-4/2 3
=5–2
302 Trackpad Information Technology (Ver. 1.0)-IX

