In this assignment, you will format a worksheet and insert appropriate formulas, and formatting.

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.