Page 6 of 16PREVNEXT

Figure out dates by using formulas

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


Which of these dates will Excel store as plain text rather than as a serial number?

June 23, 2006

23-Jun-06

June 23 2006

What would happen if you used a formula to do math with dates, but one of the dates was typed in a format that Excel doesn't recognize?

Excel would display a message telling you to reformat the date.

Excel would display an error value.

Excel would reformat the date into the correct format.

In the practice, you learned how to apply date formats to serial numbers. After selecting a cell, click the Format menu, then click:

Cells.

AutoFormat.

Conditional Formatting.

8/22/2009 and 22-Aug-2009 are stored as different serial numbers.

True.

False.

Page 6 of 16PREVNEXT