Music Playerz Lab

Instructions Part $1$: Basic Formatting and Saving

All of the following instructions apply to the worksheet called "Your Work." Format currency as currency with two decimals by selecting the data and clicking the $ in the menu bar. Format percents as percents with one decimal by selecting the appropriate data, clicking the $\%$ sign; and format numbers with comma style with no decimals by clicking the comma button. For all formats, click the "Increase Decimal" or "Decrease Decimal" icon buttons as needed.

Change the fill color of the cells in row A$16$:G$16$ from gray to a dark blue color and then change the font color to white.

Replace "Your Name Here" with your name in cells A$29$

$84.$ Select the Worksheet title in the $13$ rd row and make it Arial, $18$ pt$.$ bold

$9$ Part $2$: Chart

$10$

Using data from cells D$16$:D$24,$ insert a $2$D pie chart in the range H$13$:N$29$ to show the projected unit sales for each product for next year.

Click the chart title and change it to$,$ "Projected Sales $($in Units$)$ Next Year". Notice that if you

$11$

select the title and the data at the same time when you create the chart, you don't have to do this step.

$12$

Move the legend to the left by clicking "Add Chart Element" $($on the Design tab$)$ and choosing "Legend" and selecting "Left".

Notice the legend contains numbers $1-8$ but needs words. Right click on the legend and click "Select Data". In the "Horizontal $($Category$)$ Axis Labels" area, click the "Edit" button which brings up the "Axis Labels" dialog box. Select the data with the titles and click OK which takes you back to the "Select Data Source" dialog box. Click $"$OK$".$ Make sure that you can read all the product