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:
More number formats
Any of the above
8/22/2011 and 22-August-2011 are stored as different serial numbers.