POST CIS112 2018 November Unit 6 Assignment Latest

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.