Practical Problems: Music On Demand (Exam v3)
Question 1: Formatting and charts (TCOs 1, 2, and 3; 30 points)
1. Adjust
the widths of the columns so all data is visible.2. Center
the title “Music on Demand – Sales by Product” across columns A-D.3. Increase
the font size to 16, and change the font color to red.4. Bold
the column headings “Product”, “Unit Price”, “Quantity”, and “Total Sales”.5. Add
formulas to the Total Sales column to calculate the total sales fo..