Use the Quick Analysis gallery to insert a Clustered Bar Chart. Click the Quick Analysis button, click Totals, and then click the second Sum button to create row totals. Copy the formatting from cell E3 to F3.5. In cell F3, type Total to enter a column heading. Use a Cell Style to create a double-underline below the totals.4. Click the Quick Analysis button, click Totals, and then click Sum. In cell A6, type Net Sales to enter a row heading.3. Save the file with file name Lab 7 – 1 Custom Fragrances Complete.2.
Open the workbook, Lab 7– 1 Custom Fragrances from the Data Files. Please contact your instructor for information about accessing the Data Files.Problem: Custom Fragrances has prepared an annual sales analysis but would like to show the data in a more visual way, along with grand totals (Figure 7–94).Figure 7–94Instructions Part 1: Perform the following tasks:1.
This problem has been solved: Solutions for Chapter MEM7 Problem 1L: Using the Quick Analysis Gallery and Formatting a Bar ChartNote: To complete these steps, you will be required to use the Data Files.
0 kommentar(er)
