Excel Assignment 2
This week you will continue to work with the scenario from last week. The owner thinks it will be easier to look at sales and profits if charts are used. The owner also wants to identify the Class which was not creating as much revenue as the others.
Use your spreadsheet from last week. If you did not calculate the sales in column E within the spreadsheet, fill in that column with numbers.
Create a column chart of the monthly sales based on class. Select the range A2:D5 to create the graph.
The months should display in the legend.
Give the chart a title of Monthly Sales.
Give the vertical, y-axis a title of Sales in $.
Create a pie chart showing the profit for the month of April for all three classes
Give the chart a title of April’s Sales.
The legend should display the three class names.
Create a line chart of monthly sales based on class. Select the range the same range that you used for the column chart.
Give the chart a title of Monthly Sales.
Give the y-axis a title of Sales in $.
Display the legend for both the column and line chart on the right. The legend and months should display if columns and rows are properly selected.
Change the sheet tab name to Sales
Place a comment in cell A1 with your full name and GID number
Save the spreadsheet with the filename CS105_Wk7_YourLastName_YourFirstName_YourGIDNumber
The charts should look something like the ones below. The actual charts, of course, will depend on your spreadsheet numbers.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more