Page 6 of 16PREVNEXT

Learn how to figure out dates using formulas in Excel 2007

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, 2012


June 23 2012

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 does not recognize as a date?

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, go to the Home tab, and select the Number group. Click the arrow in the Number format box. Then click:

Short date

Long date

More number formats

Any of the above

8/22/2011 and 22-August-2011 are stored as different serial numbers.



Page 6 of 16PREVNEXT