Entering Text
Having learnt about Worksheets and Workbooks, Sean now wants to use text to display non-numerical information such as student names and the marks they obtained in the second terminal examination.
To enter text in a cell,
1. Select a cell and start typing.
TIP:
- To move to the cell below the active cell, press Enter.
- To move to the cell adjacent to the active cell, press Tab.
Activity: Type the following information in your spreadsheet.
1. Ensure that the first cell A1 is selected.
2. Now type: Second Terminal Examination Results
As you go along, you will notice that a blinking cursor appears in front of every character that you type. You will also notice that your text appears in the formula bar as well.
3. After you have finished typing, press Enter.
The current cell becomes deselected, and the outlined border now moves to the cell below it, A2.
Another thing that you will notice is that the last portion of the text in cell A1 appears to flow over the column A into the adjacent cells in columns B, C, and D. In fact, if you look closely, the common borders between the cells seem to have disappeared. Don’t worry. Your text is safely in cell A1.
4. Now, type the following:
Cell A1 — Second Terminal Examination Results
Cell A2 — Roll No
Cell B2 — Name
Cell C2 — English (100)
Note:
- The text appears in the formula bar, too.
- Although the last portion of the text in cell A1 appears to flow over column A and into the adjacent cells in columns B, C, and D, don’t worry. The borders between the cells have not disappeared and your text continues to be safely in cell A1.
