Download this spreadsheet, analyze the data and send the final Excel worksheet to me.

oxre13
timer Asked: Jul 20th, 2018

Question Description

Case Study #2 is a data exercise using an Excel spreadsheet to manipulate & tell a story using data.

In the Supply Chain/Logistics world, we actively use Excel to provide us (and our bosses) with information.

In this situation, you've been given this raw data and need to analyze and format the information by using various Excel functions.

So, download this spreadsheet, analyze the data and send the final Excel worksheet to me
Please do the following analysis and formatting:

1. Add the $ sign to the Unit Cost column;

2. Determine the Total Sales for each item (multiply Units Sold times Unit Price);

3. Highlight in bold the Column Headings, center the Headings and then place a solid Border around each data cells (forming a grid);

4. Add filters to the data and sort the data by ITEM from A-Z;

5. Calculate the Sum Total of the Total Column (create a total at the bottom of the column);

6. Bold this Sum Total in bright yellow highlight;

7. Subtotal each of the items (Binders, Desk, Pens, Pen Sets & Pencils);

8. Using the Item Subtotals and the Sum Total, calculate the percent % that each Item Subtotal represents of the Sum Total.

9. Create either a visual chart - either a Bar Chart or a Pie Chart with the Item and the % Percent of Sales.

Let me know if you have any questions.

Unformatted Attachment Preview

OrderDate 1/6/2010 1/23/2010 2/9/2010 2/26/2010 3/15/2010 4/1/2010 4/18/2010 5/5/2010 5/22/2010 6/8/2010 6/25/2010 7/12/2010 7/29/2010 8/15/2010 9/1/2010 9/18/2010 10/5/2010 10/22/2010 11/8/2010 11/25/2010 12/12/2010 12/29/2010 1/15/2011 2/1/2011 2/18/2011 3/7/2011 3/24/2011 4/10/2011 4/27/2011 5/14/2011 5/31/2011 6/17/2011 7/4/2011 7/21/2011 8/7/2011 8/24/2011 9/10/2011 9/27/2011 10/14/2011 10/31/2011 11/17/2011 12/4/2011 12/21/2011 Region East Central Central Central West East Central Central West East Central East East East Central East Central East East Central Central East Central Central East West Central Central East Central Central Central East Central Central West Central West West Central Central Central Central Rep Jones Kivell Jardine Gill Sorvino Jones Andrews Jardine Thompson Jones Morgan Howard Parent Jones Smith Jones Morgan Jones Parent Kivell Smith Parent Gill Smith Jones Sorvino Jardine Andrews Howard Gill Gill Kivell Jones Morgan Kivell Sorvino Gill Sorvino Thompson Andrews Jardine Jardine Andrews Item Units Sold Unit Cost Total Sales Pencil 95 1.99 $ Binder 50 19.99 $ Pencil 36 4.99 $ Pen 27 19.99 $ Pencil 56 2.99 $ Binder 60 4.99 $ Pencil 75 1.99 $ Pencil 90 4.99 $ Pencil 32 1.99 $ Binder 60 8.99 $ Pencil 90 4.99 $ Binder 29 1.99 $ Binder 81 19.99 $ Pencil 35 4.99 $ Desk 2 125 $ Pen Set 16 15.99 $ Binder 28 8.99 $ Pen 64 8.99 $ Pen 15 19.99 $ Pen Set 96 4.99 $ Pencil 67 1.29 $ Pen Set 74 15.99 $ Binder 46 8.99 $ Binder 87 15 $ Binder 4 4.99 $ Binder 7 19.99 $ Pen Set 50 4.99 $ Pencil 66 1.99 $ Pen 96 4.99 $ Pencil 53 1.29 $ Binder 80 8.99 $ Desk 5 125 $ Pen Set 62 4.99 $ Pen Set 55 12.49 $ Pen Set 42 23.95 $ Desk 3 275 $ Pencil 7 1.29 $ Pen 76 1.99 $ Binder 57 19.99 $ Pencil 14 1.29 $ Binder 11 4.99 $ Binder 94 19.99 $ Binder 28 4.99 $ -
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors