Excel Time Formatting and Entry Quiz

What is the first step in formatting cells to display time in Excel?

• Select the cell and choose 'Format Cells'

• Right-click on the cell

• Double-click the cell

• Type the time directly into the cell

Which tab in the 'Format Cells' dialog box allows you to set the cell format to time?

• Border

• Font

• Alignment

• Number

What time format is selected in the video for displaying time?

• Hour and minute with AM/PM

• Day and time

• 24-hour format

• Minutes and seconds

How do you enter 7 AM into a cell after formatting it for time?

• Type '07:00' and press Enter

• Type '7:00' and press Enter

• Type '7:00 AM' and press Enter

• Type '7 AM' and press Enter

What is the final step after entering the time values in the cells?

• Highlight the cells again

• Change the cell color

• Save the spreadsheet

• Preview the completed timesheet