answer all the blanks and see the picture of the excel spreadsheet In cells A2:A6 you will

answer all the blanks and see the picture of the excel spreadsheet

Transcribed Image Text:

In cells A2:A6 you will find numbers. We would like to change those numbers into actual dates using cells B2:B6. To accomplish this, enter =A2 into cell B2. That will essentially copy A2 into B2 using a formula. Next drag down B2 to B6 to fill down. Finally, select cells B2:B6, navigate to the Home tab, locate number formatting, and then use the down arrow to select Short Date. Now, cells B2:B6 should be proper dates. Enter the date for B6 exactly as it appears in the blank below: B6: Notice the pattern. Look at the dates in B2 and B3 and the corresponding numbers in A2 and A3. The date in B3 is the 11th of the month. Notice the date in B5 and the number in A5. Knowing that a year is approximately 365 days, the number in A5 and the date in B5 should make sense. Fractional Dates Excel can also accept fractional dates. In cells A9:A11 you will see numbers that have a decimal component. The decimal represents part of a day. For example, a number ending in 0.5 will be halfway through the day or 12:00 PM / noon. Repeat the same process as above to populate cells B9: B11 with the same numbers as A9:A11. Formatting B9:B11 will be a little different. To get Excel to show the partial date in cells B9:B11 highlight those cells, navigate to the Home tab, locate number formatting, and then use the down arrow to select More Number Formats. This opens a dialog box where you can apply custom formats. Under Date, find a format that also shows the time, e.g., if A9 contains 40368.25: Number Format Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Sample 7/9/10 6:00 AM Type: March 14, 2012 3/14/12 1:30 PM 3/14/12 13:30 M M-12 3/14/2012 14-Mar-2012 Locale (location): English (United States) X In cells A2:A6 you will find numbers. We would like to change those numbers into actual dates using cells B2:B6. To accomplish this, enter =A2 into cell B2. That will essentially copy A2 into B2 using a formula. Next drag down B2 to B6 to fill down. Finally, select cells B2:B6, navigate to the Home tab, locate number formatting, and then use the down arrow to select Short Date. Now, cells B2:B6 should be proper dates. Enter the date for B6 exactly as it appears in the blank below: B6: Notice the pattern. Look at the dates in B2 and B3 and the corresponding numbers in A2 and A3. The date in B3 is the 11th of the month. Notice the date in B5 and the number in A5. Knowing that a year is approximately 365 days, the number in A5 and the date in B5 should make sense. Fractional Dates Excel can also accept fractional dates. In cells A9:A11 you will see numbers that have a decimal component. The decimal represents part of a day. For example, a number ending in 0.5 will be halfway through the day or 12:00 PM / noon. Repeat the same process as above to populate cells B9: B11 with the same numbers as A9:A11. Formatting B9:B11 will be a little different. To get Excel to show the partial date in cells B9:B11 highlight those cells, navigate to the Home tab, locate number formatting, and then use the down arrow to select More Number Formats. This opens a dialog box where you can apply custom formats. Under Date, find a format that also shows the time, e.g., if A9 contains 40368.25: Number Format Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Sample 7/9/10 6:00 AM Type: March 14, 2012 3/14/12 1:30 PM 3/14/12 13:30 M M-12 3/14/2012 14-Mar-2012 Locale (location): English (United States) X