Excel Project 3-3 - SIMnet - Blue Lake Sporting Goods - Full answer in 2025 - Step-by-step

Explode a pie slice.
Delete the legend from a chart.
Reposition data labels in a chart.
Create a clustered bar chart object.
Format data labels and data series.
Add Alt Text to a chart.
Insert and format sparklines in a worksheet.
Steps to complete This Project
Mark the steps as checked when you complete them.
1. Open the BlueLake-03 start file. If the workbook opens in Protected View, click the
Enable Editing button so you can modify it. The file will be renamed automatically to
include your name. Change the project file name if directed to do so by your instructor, and
save it.
2. Create a pie chart object.
a.
b.
Select the Revenue by Department sheet, select cells A4:F4, press command,
and select cells A13:F13.
Click the Pie Chart button [Insert tab, Charts group] and choose 3-D Pie.
3. Apply a chart style.
a.
b.
c.
Select the chart object if necessary.
Click the More button [Chart Design tab, Chart Styles group].
Select Style 3.
4. Size and position a chart object.
a.
b.
c.
d.
Point to the chart object border to display the move pointer.
Drag the chart object so its top-left corner is at cell H4.
Point to the bottom right selection handle to display the resize arrow.
Drag the pointer to reach cell Q19.
5. Explode a pie slice.
a.
b.
Double-click the pie to open its Format Data Series task pane.
Click the San Diego slice to update the pane to the Format Data Point task pane.
(Rest the pointer on a slice to see its identifying ScreenTip or refer to the legend.)
https://mdchialeah.simnetonline.com/sp/assignments/projects/details/8567505
Page 2 of 8
Excel Project 3-3 - SIMnet
2/10/24, 9:08 PM
c.
d.
e.
Click the Series Options button in the Format Data Point task pane.
Set the pie explosion percentage at 10%.
Close the task pane and click the chart object border to deselect the San Diego