Questions (25 points) - Google Form

Application (25 points)

1. Open a Blank Workbook
2. Rename worksheet as SS - 2024 and change tab color to black
3. Merge & Center A1:I2 with text Scooper Shirt Sales and fill color to red    
4. Select range A4:I24 then change fill color to gray
5. Format Row 4 with angle counterclockwise, borders, middle align, center text, and bold (headings as follows: Shirt Style, Small, Medium, Large, XL, XXL, Total Sold, Cost per Shirt, and Total Revenue)
6. Short Sleeve (Cost $13.95); Numbers Sold: 14S, 15M, 11L, 10XL, 8XXL
7. Long Sleeve (Cost $21.95); Numbers Sold: 13S, 14M, 17L, 14XL, 9XXL
8. Polo (Cost $25.95); Numbers Sold: 4S, 4M, 7L, 3XL, 4XXL
9. Hoodie (Cost $33.95); Numbers Sold: 11S, 13M, 13L, 11XL, 9XXL
10. Use formulas to calculate Total Sold and Total Revenue; use formula to show total shirts sold in cell G9, and use formula to show total revenue in cell I9
11. Format cell G9 and I9 with Top and Double Bottom Border
12. Format columns H and I with currency
13. Fill cell G9 to cell B9 to calculate totals for shirt styles and type Totals in cell A9 (right align cell A9)
14. Insert chart showing shirt revenue (include chart title and appropriate labels) and type one sentence below chart of why you chose that chart type
15. Insert an image of Scooper Sam to the left of your chart below the data
16. In cell A27, type Revenue Goal:
    In cell A28, type 4750 (format with currency)
    In cell B27, use if function to display if we met the goal of $4750 for Total Revenue (align right)
17. Save as username24Sales (if Excel) and Submit/Share for grading