Mass

Introduction the spreadsheet below will be your working document. Go ahead and click en the link to navigate to the spreafibher. Oftentimes you will need to change the formatting of a cell to the date format so that it displays correctly, fut undermath every dati is a number. Latrs practice and see now this works.

The data has been collected in the Morosoft Excel Online file below. Open the spreadsheet and perform the required analysis to ansier the questions below. appear in Excel using your keyboard.

Open spreadsheet

Date Fundamentals A$2$ into B$2$ using a formula. Next drap down B$2$ to B$6$ to fill down. Finally, select cells B$2.$B$6,$ navigate to the reome tab, locate number formatting, and then use the down arrow to select Short Date. Now, cells B$2$:B$6$ should be proper dates. Enter the date for B$6$ exactly as it appears in the Blank Below:

$86$: $q,$ EnE $2012$ Knowing that a year is approximately $365$ days, the number in A$5$ and the date in B$5$ should make senie$.$

Fractional Dates $0\mathrm{.}5$ mill be hallmay through the day or $12$:$00$ PM $/$ noon.

Repeat the same process as above to populate cells B$9$:B$11$ with the same numbers as A$9$:A$11.$ Formarring B$9-$B$11$ will be a lime cifferent. To get Excel to show the partial date in You can apply custom formats. Under Date, find a format that also shows the time, e$.$e$.,$ if A$9$ contains $40358\mathrm{.}25$ :

Astosered at $6\mathrm{.}46$ PM

Nete