can someone help me with 9a & 9b. i got stuck on those and im just posting other question i might need help later! Thanks
final figure
9. In cell G22, Allison wants to display the total fundraising sales from the previous year. This data is stored in another workbook. Insert the total as follows: a. Open the file Support_Ex19_5b_Fundraisers.xlsx. b. In cell G22 of Allison's workbook, insert a formula using an external reference to cell F20 in the All Schools worksheet in the Support_EX19_5b_Fundraisers.xIsx workbook. 10. Allison wants to visualize how the sales of each cookie dough flavor contributed to the total fundraising sales for the year. Create a chart as follows to illustrate this information: a. Create a 3-D Pie chart that shows how each cookie dough flavor (range B15:B19) contributed to the total sales (range G15:G19). b. Move and resize the chart so that the upper-left corner is in cell B23 and the lower-right corner is in cell G38. 11. Format the 3-D Pie chart as follows to make it easier to interpret: a. Use Fundraising Sales as the chart title. b. Add data labels to the chart on the Inside End of each slice. c. Display only the Category Name and Percentage values in the data labels. d. Change the number format of the data labels to Percentage with 1 decimal place. e. Explode the largest slice (Chocolate chip) by 5 percent. f. Remove the legend, which repeats information in the data labels. 12. Prepare for printing the Al/ 5 chools worksheet as follows: a. Change the left and right margins to 0.5. b. Select the range B1:G39 as the print area. c. Insert a footer that displays the Sheet Name in the center section. 13. Allison wants to compare sales for Quarters 1 and 4 but doesn't want to clutter the All Schools worksheet with another chart. Create a new worksheet and chart for this comparison as follows: a. Create a worksheet using Quarterly Comparison as the worksheet name. b. In cell A1, type Fundraising Sales, and then resize column A to its best fit. c. In cell B1, enter a formula using a worksheet reference to display the total sales amount from cell G20 on the All Schools worksheet, and then resize column B to its best fit. d. Return to the All Schools worksheet, insert a Clustered Column chart based on the nonadjacent ranges B14:C19 and F14:F19, and then move the Clustered Column chart to the Quarterly Comparison worksheet. e. Position the Clustered Column chart so that its upper-left corner is in cell A3. 14. Allison wants to use a copy of the Elementary school worksheet as a template to give to other schools. Copy the worksheet as follows: a. Create a copy of the Elementary School worksheet at the end of the workbook. b. Rename the copy using Other School as the worksheet name. c. On the Other School worksheet, clear only the contents from the cells containing data, not formulas, in the range B6:E10 and cell H2. Jefferson School Cookie Dough Fundraisers Cookie Dough Fundraisers Fundraising Sales \|\|\|\| 9. In cell G22, Allison wants to display the total fundraising sales from the previous year. This data is stored in another workbook. Insert the total as follows: a. Open the file Support_Ex19_5b_Fundraisers.xlsx. b. In cell G22 of Allison's workbook, insert a formula using an external reference to cell F20 in the All Schools worksheet in the Support_EX19_5b_Fundraisers.xIsx workbook. 10. Allison wants to visualize how the sales of each cookie dough flavor contributed to the total fundraising sales for the year. Create a chart as follows to illustrate this information: a. Create a 3-D Pie chart that shows how each cookie dough flavor (range B15:B19) contributed to the total sales (range G15:G19). b. Move and resize the chart so that the upper-left corner is in cell B23 and the lower-right corner is in cell G38. 11. Format the 3-D Pie chart as follows to make it easier to interpret: a. Use Fundraising Sales as the chart title. b. Add data labels to the chart on the Inside End of each slice. c. Display only the Category Name and Percentage values in the data labels. d. Change the number format of the data labels to Percentage with 1 decimal place. e. Explode the largest slice (Chocolate chip) by 5 percent. f. Remove the legend, which repeats information in the data labels. 12. Prepare for printing the Al/ 5 chools worksheet as follows: a. Change the left and right margins to 0.5. b. Select the range B1:G39 as the print area. c. Insert a footer that displays the Sheet Name in the center section. 13. Allison wants to compare sales for Quarters 1 and 4 but doesn't want to clutter the All Schools worksheet with another chart. Create a new worksheet and chart for this comparison as follows: a. Create a worksheet using Quarterly Comparison as the worksheet name. b. In cell A1, type Fundraising Sales, and then resize column A to its best fit. c. In cell B1, enter a formula using a worksheet reference to display the total sales amount from cell G20 on the All Schools worksheet, and then resize column B to its best fit. d. Return to the All Schools worksheet, insert a Clustered Column chart based on the nonadjacent ranges B14:C19 and F14:F19, and then move the Clustered Column chart to the Quarterly Comparison worksheet. e. Position the Clustered Column chart so that its upper-left corner is in cell A3. 14. Allison wants to use a copy of the Elementary school worksheet as a template to give to other schools. Copy the worksheet as follows: a. Create a copy of the Elementary School worksheet at the end of the workbook. b. Rename the copy using Other School as the worksheet name. c. On the Other School worksheet, clear only the contents from the cells containing data, not formulas, in the range B6:E10 and cell H2. Jefferson School Cookie Dough Fundraisers Cookie Dough Fundraisers Fundraising Sales \|\|\|\|
