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.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.