FOD Pre-Quiz 5B

What is the value returned from the formula in the Red Cell, with format changed to Date?

• ERROR

• BLANK

• 1-Jan-00

• 1

What is the difference between Now() and Date() in excel?

• There is no difference.

• Now() return current date & time.

  Date() return current date.

• There is no Now() function in excel.

• There is no Date() function in excel.

What is the value returned from the formula in the Red cell?

• 30-Sep-2450

• ERROR

• 5-Aug-11

• 8-May-11

What is the value returned from the formula in the Red cell?

• 31-May-11

• 1-Jun-11

• ERROR

• 21-May-7407

What is the value returned from the formula in the Red cell, format as Number?

• ERROR

• 13

• 2

• Feb

What is the value returned from the formula in the Red cell, format as time?

• ERROR

• 9:45:30AM

• 9:30:45PM

• 9:30:45AM

What is the value returned from the formula in the Red cell, format as time?

• ERROR

• 7:59:59AM

• 8:00:00AM

• 8:00:01AM

What is the value returned from the formula in the Red cell, date format?

• ERROR

• 9-Feb-23

• 10-Feb-23

• 13-Feb-23