Independent Challenge 1 You are the assistant to the vice president of marketing at the Metro-West Philharmonic located outside of Boston. The vice president has asked you to chart some information from a recent survey of the Philharmonic's customers. Your administrative assistant has entered the survey data in an Excel worksheet, which you will use to create two charts. a. Start Excel, open the file titled EX J-3.xlsx from the drive and folder where you store your Data Files, then save it as EX J-Customer Demographics. b. Using the data in A2:37 of the Education Data worksheet, create a 3-D pie chart (the first chart in the 3-D Pie group) on the worksheet. c. Move the chart to a separate sheet named Education Chart. Format the chart using chart Style 34. d. Add a title of Education Data above the chart. Format the title using WordArt Gradient Fill Dark Red, Accent 1 (fourth style in the third row). Change the chart title font to a size of 28, and center it over the chart. e. Add data labels to the outside end of the data points. Format the legend text in a 14-point font. (Hint: Use the font options on the Home tab or the Mini toolbar.) f. Select the Bachelor's degree pie slice by clicking the chart, then clicking the Bachelor's degree slice. Change the slice color to the standard color of Olive Green, Accent 3 from the Theme colors. (Hint: On the Chart Tools Format tab, click the Format Selection button in the Current Selection group and use the Format Data Point dialog box.) Compare your chart to Figure J-22. FIGURE J-22 L295 1 Higit Scrool Associate's degree Bactelor's degree Master's degree Doctoral degree Professional degree 124 124 g. On the Income Data worksheet, use the data in A2:B6 to Education Data create a standard clustered column (the first chart in the 2-D Column group) chart. h. Delete the legend. (Hint: Select the legend and press [Delete].) i. Place the chart on a new sheet named Income Chart. Format the chart using chart Style 7. j. Add a chart title of Income Data above the chart, and format the title using WordArt Style Gradient Fill - Blue, Accent 4, Reflection. k. Title the category axis Income. Format the category axis title in 18-point bold. (Hint: Use the font options on the Home tab or use the Mini toolbar.) 1. Enter your name in the center sections of the footers of the Income Chart and Education Chart sheets. m. Save the workbook, preview the Income Chart and the Education Chart sheets. n. Close the workbook, submit the workbook to your instructor, and exit Excel. 224 Independent Challenge 1 You are the assistant to the vice president of marketing at the Metro-West Philharmonic located outside of Boston. The vice president has asked you to chart some information from a recent survey of the Philharmonic's customers. Your administrative assistant has entered the survey data in an Excel worksheet, which you will use to create two charts. a. Start Excel, open the file titled EX J-3.xlsx from the drive and folder where you store your Data Files, then save it as EX J-Customer Demographics. b. Using the data in A2:37 of the Education Data worksheet, create a 3-D pie chart (the first chart in the 3-D Pie group) on the worksheet. c. Move the chart to a separate sheet named Education Chart. Format the chart using chart Style 34. d. Add a title of Education Data above the chart. Format the title using WordArt Gradient Fill Dark Red, Accent 1 (fourth style in the third row). Change the chart title font to a size of 28, and center it over the chart. e. Add data labels to the outside end of the data points. Format the legend text in a 14-point font. (Hint: Use the font options on the Home tab or the Mini toolbar.) f. Select the Bachelor's degree pie slice by clicking the chart, then clicking the Bachelor's degree slice. Change the slice color to the standard color of Olive Green, Accent 3 from the Theme colors. (Hint: On the Chart Tools Format tab, click the Format Selection button in the Current Selection group and use the Format Data Point dialog box.) Compare your chart to Figure J-22. FIGURE J-22 L295 1 Higit Scrool Associate's degree Bactelor's degree Master's degree Doctoral degree Professional degree 124 124 g. On the Income Data worksheet, use the data in A2:B6 to Education Data create a standard clustered column (the first chart in the 2-D Column group) chart. h. Delete the legend. (Hint: Select the legend and press [Delete].) i. Place the chart on a new sheet named Income Chart. Format the chart using chart Style 7. j. Add a chart title of Income Data above the chart, and format the title using WordArt Style Gradient Fill - Blue, Accent 4, Reflection. k. Title the category axis Income. Format the category axis title in 18-point bold. (Hint: Use the font options on the Home tab or use the Mini toolbar.) 1. Enter your name in the center sections of the footers of the Income Chart and Education Chart sheets. m. Save the workbook, preview the Income Chart and the Education Chart sheets. n. Close the workbook, submit the workbook to your instructor, and exit Excel. 224
