File Home Insert Page Layout Formulas Data Review View Help X Cut Calibri 11 ~ AA = ab Wrap Text General Style 1 Normal Bad Paste [B) Copy Format Painter BIUY CE E Merge & Center $ ~ % " Conditional Format as Neutral Calculation Ch Formatting * Table Clipboard Font Alignment Number Styles F23 X V A B C D G H Any Town Elementary School School Supplies Distribution Classroom Supplies Cost/Unit Sept. Units Sept. Cost % of Grand Total Oct. Units Oct. Cost % of Grand Total #2 Pencils $0.75 29 $21.75 3% 12 Colored Pencils $2.29 60 $137.40 28 Copy Paper $3.99 40 $159.60 32 Crayons $3.10 15 46.50 7 Hand Sanitizer $2.00 16 $32.00 7 0 Highlighters $3.29 12 $39.48 10 Markers $4.79 35 $167.65 22 12 Pens $4.00 22 $88.00 8 13 Staples $1.89 12 $22.68 Tissues $1.49 22 $32.78 16PENN FOSTER 12 Staples $1.89 12 13 Tissues $1.49 22 OURSE 14 Hand Sanitizer $2.0 16 HOME 15 ESSONS 7. In column D, enter appropriate formulas to calculate the September costs for each school supply. Your formulas must use cell references. Format the calculated values as Currency with 2 decimal places. 8. In cell A16, enter the label "Grand Total" and format it as bold. 9. In cell D16, enter a formula that uses a function to calculate the total of the column. 10. In column E, enter formulas that calculate the percentage of the grand total for each type of school supply (total cost of each item divided by the grand total). Your formulas must use appropriate absolute cell references. Format the calculated values as Percentage with 0 decimal places. 11. In cell E16, enter a formula that uses a function to calculate the total of the column (it should total 100%). 12. Repeat the process you used in steps 7-11 to calculate values for October. 13. Sort the school supplies alphabetically. (Be sure to select cells A5:H14 to sort the entire row of data.) Your spreadsheet should look similar to the figure below. B C D F G H Any Town Elementary School School Supplies Distribution 3 4 Classroom Supplies Cost/Unit Sept. Units Sept. Cost % of Grand Total Oct. Units Oct. Cost % of Grand Total 5 #2 Pencils $0.75 29 $21.75 3% 12 $9.00 2% 6 Colored Pencils $2.29 60 $137.40 18% 28 $64.12 15% 7 Copy Paper $3.99 40 $159.60 21% $127.68 30% 8 Crayons $3.10 15 $46.50 6% $21.70 5% 9 Hand Sanitizer $2.00 16 $32.00 4% $14.00 3% 10 Highlighters $3.29 12 $39.48 5% 10 $32.90 8% 11 Markers $4.79 35 $167.65 22% 22 $105.38 25% 12 Pens $4.00 22 $88.00 12% $32.00 7% 13 Staples $1.89 12 $22.68 3% $7.56 2% 14 Tissues $1.49 22 $32.78 4% $13.41 3% 15 16 Grand Total $747.84 100% $427.75 100% 47 14. Save the modified spreadsheet