Page 52 - TP_Prime_v2.2_Class_5
P. 52
The names of default worksheets are Sheet 1, Sheet 2, Sheet 3, etc. To add a
worksheet, click on the plus sign on the right of the sheet tab.
• Rows and Columns: Columns are the vertical sections of the table, whereas Rows
are the horizontal sections of the table. A table in Word can have a maximum of
63 columns but the number of rows is unlimited.
• Cells: Cells are the intersection of rows and columns. It is the smallest unit in a
Prime (Ver. 2.2)-V • Worksheet: The worksheet is divided into Rows and Columns. The rows are
worksheet and can hold numbers, text or formula.
numbered as 1, 2, 3, 4… as indicated by the Row Headers on the left side of the
workspace. The columns are labelled alphabetically as A, B, C, D…Z, AA…AZ,… as
indicated by the Column Headers at the top of the workspace. The total number
of columns in Excel is 16,384. The total number of rows is 1,048,576.
50 • Active Cell: As the name suggests, it is the cell that is currently active or selected.
It can be recognised by its green outline. You can type data into an active cell only.
• Formula Bar: It displays the contents of the active cell. You can also type or edit
data and formulas in the formula bar.
Changing the Active Cell
To change the active cell in a worksheet, you can either use the keyboard or the mouse
pointer. When working with a mouse, just click on the cell you want to make active.
Given below are the keys and their functions to change the active cell in a worksheet:
Key Function
Enter key Moves the active cell down one row
Shift + Enter key Moves the active cell one row up
Shift + Tab key Moves the active cell one column to the left
Tab key Moves the active cell one column to the right
ß [left arrow key] Moves the active cell one column to the left
à [right arrow key] Moves the active cell one column to the right
á [up arrow key] Moves the active cell one row up
â [down arrow key] Moves the active cell one row down
Ctrl + Home key Moves the active cell to the first cell i.e. A1
Ctrl + End key Moves the active cell to the last used cell on the worksheet

