Page 44 - CloudGPT_C5_Flipbook
P. 44
Formula Bar: It displays the contents of the active cell. You can also type or edit data and
formulas in the formula bar.
Name Box: It displays address of the active cell. It is present on the left side of the formula
bar.
Topic Flashback 21 st Century #Technology Literacy
Skills #Critical Thinking
Match the following:
1. Row header a. Address of the active cell
2. Column header b. Displays content of active cell
3. Sheet tab c. Row numbers
4. Name box d. Column labels
5. Formula bar e. Displays number of worksheets in a workbook
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
Premium Edition-V
42

