Page 68 - TP_Plus_v4_Class4
P. 68
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:
2 Click on Home Select Date option in the 4
tab. Category section.
Click on the Number
format dialog box 3
Select the cell launcher.
where you
want to edit
the date or Choose the format 5
1
time. you want.
6
Click on OK button.
Hintbot
To apply the default date format: Ctrl + Shift + #
To apply the default time format: Ctrl + Shift + @
21 st
Double Tap Century #Technology Literacy
Skills
Answer the following in one or two words:
1. What is the shortcut to select the whole worksheet?
2. Which key is used to select a range of cells?
3. Which key is used to select the multiple cells?
4. What is the shortcut to apply the default time format?
66 PLUS (Ver. 4.0)-V

