StudyXY
RegisterLog in

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.9
45
6 months ago
Preview (2 of 3 Pages)
100%
Purchase to unlock

Page 1

Excel Data Analysis and Pivot Table Creation: MIS 140 Part 2 Assignment - Page 1 preview image

Loading page ...

Excel Data Analysis and Pivot Table Creation: MIS 140 Part 2AssignmentIn the MIS 140 Excel–Part 2 Assignment, you are required to create and manipulate multiplePivot Tables to analyze data from the provided Pens & Things Office Supplies dataset. Completeall 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 eachCustomer, 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 itemper Customer and the number of items per color for each Customer, what challenges didyou encounter, and how did you resolve them? (250 words minimum)3.Discuss how you used the filter options and the formatting techniques (such as boldingand increasing font size) to make the Pivot Table data easily understandable whenpreparing your final spreadsheet for submission. (200 words minimum)Your answer should be thorough, covering each part of the assignment and demonstrating anunderstanding 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

Preview Mode

This document has 3 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

University
California State University
Course
MIS 140
Subject
Business Management

Related Documents

View all
Solved Assignments

CIS 337 Unit 7 Assignment Final Project Part IV Pr

CIS 337 final project presentation for stakeholders outlining a WAN proposal for a growing organization. Covers network planning, topology, security, and connectivity to support national and international expansion.

Class Notes

Analysis of Leadership in Monster Inc

In Monsters, Inc., leaders reflect Path-Goal Theory: Sulley shifts from supportive to achievement-oriented, while Waternoose is directive—each showing strengths, flaws, and growth paths.

Class Presentation

Evaluation of Alphabet's Mission, Vision, and 8-29

Alphabet Inc.'s mission is to organize the world's information and make it universally accessible and useful . Their vision is to create a future where technology improves lives and solves global challenges.

Class Notes

Boundless Management

Global corporations (MNCs) operate in multiple countries, using economies of scale and scope to grow revenue and cut costs. They face challenges like ethics and leadership while targeting fast-growing markets such as China and India.

Solved Assignments

Uncovering the Martha Stewart Tax Scandal Insider

Summary of Martha Stewart's insider trading and tax evasion scandal involving ImClone stock in 2001. She was convicted of conspiracy, obstruction, lying, and failing to pay \$220K in taxes on her NY home.

Class Notes

Boundless Business

Learn about the three key management levels—top, middle, and low—in a business hierarchy. Understand their roles, responsibilities, and how they work together to lead, plan, and supervise within an organization.

Solved Assignments

JetBlue Airlines Case Analysis

JetBlue Airlines case study analyzing market forces, competition, and strategy using Mullin's framework, Porter's Five Forces, PESTEL, VRIO, and Business Model Canvas for strategic insights.

Class Notes

Effective Speaker Notes Template for BUS 210 Prese

Presentation outlines SNHU Pet Supply’s mission to provide quality pet products and emphasizes informal leadership to foster a positive work environment and achieve company goals.

Class Notes

Leading as a Function of Management

Explore the essential management function of leading—learn how motivation, communication, decision-making, and coaching drive team success and organizational growth through effective leadership strategies.

Class Notes

McDonald's Q4 Earnings U

McDonald's U.S. sales fell 1.4% in Q4 due to lower customer spending and an E. coli outbreak. Despite this, strong international performance and global expansion plans lifted shares 4.8%, making McDonald's the top Dow performer on the day.