Excel Time Management Quiz

What is the main issue with the time worked on Friday in the Excel spreadsheet?

• The time is calculated in a different time zone.

• The time is missing for Friday.

• The time worked goes past midnight.

• The time is not formatted correctly.

What is the first step in correcting the time calculation for Friday using the IF formula?

• Clear the cell by hitting the delete key.

• Add 1 to the end time.

• Click on the start time cell.

• Type in the formula directly.

In the IF formula, what does adding 1 to the end time account for?

• Time zone differences.

• Incorrect time format.

• The start time being greater than the end time.

• Daylight saving time.

How does Excel internally handle time values?

• As hexadecimal values.

• As binary code.

• As mathematical values.

• As text strings.

What is the decimal representation of 7 PM in Excel?

• 0.79

• 0.29

• 0.5

• 0.75