Create a 3-D clustered column chart to display the quarterly low end sales, expected sales, and high end sales on a separate sheet with an appropriate sheet name.

Topic: Week 1 Assignment

The scenario:

All That Glitter Jewelry is considering an expansion of the company website to sell more merchandise. Wanda Delana, US Sales Director, has asked you to complete the proposal.

To complete this assignment you will need the following files:

Web_Sales_chart Web_Sales_Proposal

You will save your files as: Lastname_Firstname_ Web_Sales_Chart Lastname_Firstname_Web_Sales_Proposal Open the provided file, Web_Sales_Chart file, and then save the Excel workbook as Lastname_Firstname_ Web_Sales_Chart.

Complete the Excel worksheet Insert totals in row 10, Merge and center the titles Format data for aesthetics

Create a 3-D clustered column chart to display the quarterly low end sales, expected sales, and high end sales on a separate sheet with an appropriate sheet name.

Modify the chart style and format appropriate chart elements

Insert the file name in the footer and add appropriate document properties

Open the provided file, Web_Sales_Proposal file, and then save the Word document as Lastname_Firstname_Web_Sales_Proposal

In the Word document include the linked Excel data and chart Insert the your name in the footer

Create a 3-D clustered column chart to display the quarterly low end sales, expected sales, and high end sales on a separate sheet with an appropriate sheet name.