Excel Date and Time Entry Quiz

What is the correct way to enter a date in Excel for September 28th?

• September 28

• 28/9

• 9-28

• 28-9

How does Excel internally represent dates?

• As text

• As numbers

• As formulas

• As images

What happens if you enter an invalid date like September 31st in Excel?

• It gets automatically corrected

• It is left aligned as text

• It shows an error message

• It gets deleted

How can you change a time entry from AM to PM in Excel?

• By typing 'PM' after the time

• By using a 24-hour format

• By using a different font

• By changing the cell color

What is the 24-hour format for 5 PM?

• 17:00

• 05:00

• 15:00

• 07:00