Excel Data Analysis and Pivot Table Creation: MIS 140 Part 2 Assignment

Preview 2 of 3 pages

See the first 2 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Excel Data Analysis and Pivot Table Creation: MIS 140 Part 2 Assignment In the MIS 140 Excel – Part 2 Assignment, you are required to create and manipulate multiple Pivot Tables to analyze data from the provided Pens & Things Office Supplies dataset. Complete all of the tasks in the instructions and answer the following questions: 1. Explain how you created the Pivot Table to display the number of items sold for each Customer, and describe any key features of the Pivot Table that helped organize this data. (200 words minimum) 2. For the tasks that involve manipulating Pivot Tables to show the total sold for each item per Customer and the number of items per color for each Customer, what challenges did you encounter, and how did you resolve them? (250 words minimum) 3. Discuss how you used the filter options and the formatting techniques (such as bolding and increasing font size) to make the Pivot Table data easily understandable when preparing your final spreadsheet for submission. (200 words minimum) Your answer should be thorough, covering each part of the assignment and demonstrating an understanding of how to use Pivot Tables and data filters in Excel for detailed data analysis. Word Count Requirements: • Question 1: Minimum 200 words • Question 2: Minimum 250 words • Question 3: Minimum 200 words
Page 2

1 more page in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.