Independent Challenge 1 You are the operations manager for the Chicago Arts Alliance. Each year the...

Transcribed Image Text:

Independent Challenge 1 You are the operations manager for the Chicago Arts Alliance. Each year the group revisits the number and types of activities they support to better manage their budgets. For this year's budget, you need to create charts to document the number of events in previous years. a. Start Excel, open the file EX 4-3.xlsx from the location where you store your Data Files, then save it as EX 4-Chicago Arts Alliance. TABLE 4-3 title Chart title b. Take some time to plan your charts. Which type of chart or charts might best illustrate the information you need to display? What kind of chart enhancements do you want to use? Will a 3-D effect make your chart easier to understand? c. Create a Clustered Column chart for the data. d. Change at least one of the colors used in a data series. e. Make the appropriate modifications to the chart to make it visually attractive and easier to read and understand. Include a legend to the right of the chart, and add chart titles and horizontal and vertical axis titles using the text shown in TABLE 4-3. f. Create at least two additional charts for the same data to show how different chart types display the same data. Reposition each new chart so that all charts are visible in the worksheet. One of the additional charts should be a pie chart for an appropriate data set; the other is up to you. Vertical axis title Horizontal axis title g. Modify each new chart as necessary to improve its appearance and effectiveness. A sample worksheet containing three charts based on the worksheet data is shown in FIGURE 4-27. h. Enter your name in the worksheet header. i. Save your work. Before printing, preview the worksheet in Backstage view, then adjust any settings as necessary so that all the worksheet data and charts will print on a single page. j. Submit your work to your instructor as directed. k. Close the workbook, then exit Excel. Excel 100 FIGURE 4-27 Your Name Play perce Poetry Comedy Take Show Tien Xharood Suites DAAR Punty Cedy Types a Wo Arts Types of E Working with Charts #Tour] text Chicago Arts Alliance Events Number of Events Types of Events #TIM? #Y Chicago Arts Alliance Events, Year 4 Owce ya Conly Independent Challenge 1 You are the operations manager for the Chicago Arts Alliance. Each year the group revisits the number and types of activities they support to better manage their budgets. For this year's budget, you need to create charts to document the number of events in previous years. a. Start Excel, open the file EX 4-3.xlsx from the location where you store your Data Files, then save it as EX 4-Chicago Arts Alliance. TABLE 4-3 title Chart title b. Take some time to plan your charts. Which type of chart or charts might best illustrate the information you need to display? What kind of chart enhancements do you want to use? Will a 3-D effect make your chart easier to understand? c. Create a Clustered Column chart for the data. d. Change at least one of the colors used in a data series. e. Make the appropriate modifications to the chart to make it visually attractive and easier to read and understand. Include a legend to the right of the chart, and add chart titles and horizontal and vertical axis titles using the text shown in TABLE 4-3. f. Create at least two additional charts for the same data to show how different chart types display the same data. Reposition each new chart so that all charts are visible in the worksheet. One of the additional charts should be a pie chart for an appropriate data set; the other is up to you. Vertical axis title Horizontal axis title g. Modify each new chart as necessary to improve its appearance and effectiveness. A sample worksheet containing three charts based on the worksheet data is shown in FIGURE 4-27. h. Enter your name in the worksheet header. i. Save your work. Before printing, preview the worksheet in Backstage view, then adjust any settings as necessary so that all the worksheet data and charts will print on a single page. j. Submit your work to your instructor as directed. k. Close the workbook, then exit Excel. Excel 100 FIGURE 4-27 Your Name Play perce Poetry Comedy Take Show Tien Xharood Suites DAAR Punty Cedy Types a Wo Arts Types of E Working with Charts #Tour] text Chicago Arts Alliance Events Number of Events Types of Events #TIM? #Y Chicago Arts Alliance Events, Year 4 Owce ya Conly

Answer rating: 100% (QA)

To determine the coordinates of all other angles using the balanced latitude and departures after ba... View the full answer