Download this spreadsheet, analyze the data and send the final Excel worksheet to me.
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
This question has not been answered.
Create a free account to get help with this and any other question!
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