Page 58 - TP_Prime_v2.2_Class_5
P. 58
Selecting the Whole Worksheet
To select the whole worksheet, click the Select All triangle. This button is present
above row 1.
Select All
Prime (Ver. 2.2)-V To select the entire
Soft Hint
worksheet:
Ctrl + A
21 st
56 Century #Critical Thinking
Warm Match the following: Skills
Up! 1. Row Header a. Address of the active cell
2. Column Header b. Display content of active cell
3. Name Box c. Row numbers
4. Formula Bar d. Columns numbers
Entering Date and Time
When you enter time in a cell in Excel, it looks for the hours, minutes, seconds and
am/pm. So, the default time format is hours : minutes : seconds
AM/PM. For example, 10:28:35 AM, 8:15:00 PM, 10:28 AM, 8 PM,
etc. Excel recognises all the formats given in the examples here.
Similarly, when you enter date, e.g. 10/4, Excel recognises it as
date and displays 10-Apr in the cell.
To change the format of date or time you entered, follow these steps:
Step 1: Select the cell where you want to edit the date or time.
Step 2: Click on Home tab.
Step 3: Click on the Number format dialog box launcher.

