Workflow _ student 1

docx

School

Jaypee Institute of Information Technology *

*We aren’t endorsed by this school

Course

411

Subject

Information Systems

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by ChefCrownStork26

Workflow : Student 1) Pivot Table Analysis Make a Pivot Table and Chart for Total Sales and Profit by US State - Select the "Pivot Table Data" tab after opening the spreadsheet. - Choose the data and open a new tab to build a pivot table. - Enter the numbers for Total Sales and Total Profit, and set US State as rows. - To provide a visual depiction, use a pivot chart. 2. Mission: Determine the Top 3 US States for Overall Sales - Arrange the Pivot Table in decreasing order of Total Sales. - List the top three US states. 3. Assignment: Profit Analysis in Colorado - Filter Colorado's state-specific pivot table. - Find out which year Colorado made the most money. \

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Workflow _ student 1

Related Documents