Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3 Create a workbook template that will display the total sales for each month from each branch. Use the Spreadsheet Plan on the next
Part 3 Create a workbook template that will display the total sales for each month from each branch. Use the Spreadsheet Plan on the next page to sketch this template. Columns must be wide enough to display data properly. Include a header containing the data (to the right) and footer with the le name in the lower right comer. Use Calibri font in keeping with the organisation's house style. Save the workbook le as a template with an appropriate le name in the correct tem- plates folder. Total each column and row to determine the total sales for each month and each branch. Create a chart that displays the sales for each branch over the three month period. Use an appropriate chart type and add a title. Insert the chart on a new worksheet and rename the sheet appropriately. Create a chart that displays the total sales for each branch. Use an appropriate chart type that will show which branch has the larger percentage of sales against all other branches. Use appropriate data labels and add a chart title. Explode the largest seg- ment. Insert the chart on a new worksheet and rename the sheet appropriately. Part 4 Using the template created in Part 3 produce aworkbook using the data from the workbooks created in Part 2. The workbook should be saved with an appropriate le name in your working folder. Compfe EIEIEIEIEIEIEI El
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started