Page 303 - TP_IT_V1.0_C9_flipbpookl
P. 303
Key/Keys Combination Explanation
Home Moves to the first cell of the current row.
End Moves to the last cell containing the text of the current row.
Pg Down Moves one screen down in the sheet.
Pg Up Move to one screen up on the sheet.
Ctrl + Home Makes A1 as active cell
Ctrl + End Make the last cell on the sheet with data as the active cell.
F2 Enters the active cell into the edit mode.
Ctrl + F2 Opens the Function Wizard.
Shft+Ctrl+F5 Moves the cursor to the Name Box.
Can you tell the address of:
uiz Bee • First cell of a sheet
• Last cell of a sheet
Subject: To rename a sheet
A sheet can easily be renamed by using the given steps:
1. Double-click on the sheet tab.
It will open the Rename Sheet dialog box.
2. Delete the existing sheet name and type a new name in the Name text box.
3. Click the OK button or Press the Enter key.
ENTERING DATA
When you enter a data in an active cell then it is always done using the given steps:
Step 1: Select a cell by positioning the pointer in a cell.
Step 2: Type your data in that cell.
Step 3: Press the Enter key on the keyboard or click on another cell using the mouse.
Electronic Spreadsheet 301

