Excel 2021 In Practice - Ch 3 Guided Project 3-3 - Blue Lake Sporting Goods (Update in 2025) скачать в хорошем качестве

Excel 2021 In Practice - Ch 3 Guided Project 3-3 - Blue Lake Sporting Goods (Update in 2025)

Join this channel to get access to perks:    / @calculusphysicschemaccountingt   Guided Project 3-3 Blue Lake Sporting Goods has locations in major cities. For this project, you create a pie chart and a bar chart to display each store’s contribution to golf-related sales and how total sales evolved for the period. You create a line chart to illustrate the break-even sales needed for a new item. [Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8] File Needed: BlueLake-03.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-BlueLake-03.xlsx Skills Covered in This Project Create, size, and position a pie chart object. Apply a chart style. 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. This image appears when a project instruction has changed to accommodate an update to Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate instruction instead. 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. 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. 1/5 https://sdsu.simnetonline.com/sp/assi... 8/2/25, 9:13 AM Drag the pointer to reach cell Q19. Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet d. 5. Explode a pie slice. a. b. c. d. e. 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.) 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 slice. 6. Display and format data labels. a. b. c. d. e. f. g. Click the Add Chart Element button [Chart Design tab, Chart Layouts group], and point to Data Labels to open its submenu, and choose More Data Label Options.... Verify that the Label Options group is selected in the Format Data Labels pane. Click Label Options to expand the group if it is collapsed. Select the Category Name box. Confirm that the Percentage and the Show Leader Lines boxes are selected ( Figure 3-80 Format Data Labels task pane Click the Separator drop-down list and choose (space). Figure 3-80). Click the Fill & Line button, expand the Fill group, and select No Fill. This removes the black background box for each label. h. Close the task pane. 7. Delete the legend and recolor and position data labels. a. b. c. d. e. f. g. Select the legend. Confirm your selection in the Chart Elements drop-down list [Format tab, Current Selection group]. Press Delete to remove the legend. Click the Chart Elements drop-down list [Format tab, Current Selection group] and select Series “Golf” Data Labels. All of the city names and percentages are selected. Click the Text Fill button [Format tab, WordArt Styles group] and choose Black, Text 1 (second column). Click as many times as needed to select only the San Diego data label. Point to display a move pointer and drag the label as shown in Figure 3-81. 2/5 https://sdsu.simnetonline.com/sp/assi... 8/2/25, 9:13 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet Figure 3-81 Data labels positioned by dragging each one h. i. Select each data label and position it as shown in the figure. If you accidentally move another element, press command+Z to undo the error. Click a worksheet cell. #MicrosoftExcel #Microsoft #SIMNet #GuidedProject #BlueLakeSportingGoods #Excel2021