POST CIS112 Unit 6 Assignment Latest 2018 November
CIS112 Intro to Computing
Unit 6 Assignment
MS Excel Assignment 2
In this assignment, you will format a worksheet and insert appropriate formulas, and formatting.
Please remember to save your work as you go through the steps.
The requirements for your assignment are:
1. Open the Unit 6 Charting.xlsx document;
2. Save the document as Your Initials_Unit 6_Charting.xlsx (i.e. SB_Unit6_Charting.xlsx);
3. Select Column Q on the worksheet and hide the entire column Q;
4. Format the values in cells B3:M6 as a Number format with 2 decimal points;
5. Select cell A7 and enter the text “Total”;
6. Using the SUM function, calculate the Totals for each month. Your worksheet should look
like the following:
7. Select cells A2:M6 and create a Line chart for the data; Your Line chart should look like the
following:
Note: If your chart does NOT look like the chart above, but looks like the chart below, you
should choose the Switch Row/Column
Option, which is located under the Chart
Tools Menu.
8. Adjust the size of your line chart and move it so that the chart fits in cells A12:H20.
9. Add a legend to the bottom of your line chart;
10. Add the following title to the chart: “Sales by Month by Region”. Your chart with the legend
and title should like the following:
11. Below is how your completed worksheet should look:
12. Save your document and upload into Blackboard.
Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you
write, and again after you write.
Having Trouble Meeting Your Deadline?
Get your assignment on POST CIS112 Unit 6 Assignment Latest 2018 November completed on time. avoid delay and – ORDER NOW
