Page 78 - TGPT_V5.0_C5_Flipbook
P. 78
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. Which tab contains the Borders command?
2. What is the shortcut to apply the default date format?
3. What is the shortcut to apply the default time format?
76 Premium Edition-V

