Page 86 - IT-802_class_12
P. 86
3.9.2 Text Formulas
A text string or a text value refers to a sequence of characters. Two strings can be joined together. This is called
concatenation. We use the ampersand (&) to concatenate strings.
For example, if you type =“Keep” &” “& “Smiling” in a cell and press ENTER, you will see the result as Keep Smiling.
Mathematical operations such as subtraction, multiplication, and division on strings cannot be performed on strings.
Formula with Cell Address
Each cell in the worksheet has a unique address that is formed by the intersection of its column and row, say, B13.
Here, B is the column name and 13 is the row number.
Formulas are applied to cells on the basis of the cell address that displays the output as a result of a calculation done
between data in different cell addresses.
Consider a worksheet in which the data entered in cells A1, B1, C1, and D1 are 25, 15, 30, and 50, respectively. In cell
E1, a formula is entered to calculate the sum of these numbers with their cell addresses. Thus, it will be displayed as
=A1+B1+C1+D1.
Here, the output will be 120, which will be displayed in cell E1.
Now in the next cell, i.e., F1, enter a new formula to find the average of cell values as =F1/4. Now the output 30 will
be displayed in the cell F1.
84 Touchpad Information Technology-XII

