Excel Data Analysis and Pivot Table Creation: MIS 140 Part 2 Assignment
An assignment focused on Excel data analysis, including pivot table creation for the MIS 140 course.
Michael Davis
Contributor
4.3
50
about 1 month ago
Preview (2 of 3)
Sign in to access the full document!
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
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
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
California State University
Subject
Business Management