Question: 1.Use the org data to build a Pivot table on a separate Sheet Called Pivot Org provide Slicers and Dynamic Chart 2. Use the Adv

1.Use the "org data" to build a Pivot table on a separate Sheet Called "Pivot Org" provide Slicers and Dynamic Chart 2. Use the Adv Filter sheet and build and advanced filter that finds associates that have made more that $1500

1.Use the "org data" to build a Pivot table on a 2. Use the Adv Filter sheet and build and advanced filter that finds associates that have made more that $1500

1) 15 pts. Use the "org data" to build a Pivot table on a separate Sheet Called "Pivot Org" provide Slicers and Dynamic Chart It should look like this: H J K L - Sum of Difference $0.00 Bree Point Lake w -$2,000.00 -16.000.00 1 1 -36,000.00 Classification - Associate - Manager Representative 2 -$8.000.00 3 $10.000 1 -$12,000.00 $ -$14,000.00 5 5 Location - 7 D E 1 2 3 Sum of Difference Column Labels 4 Row Labels Associate Manager Representative Grand Total 5 Baudette -$10,100.00 $8,975.00 -$3,555.00 $22,630.00 6 Breezy Point -$3,500.00 -$670.00 $4,170.00 7 Cass Lake -$4,050.00 -$445.00 -$11,850.00 $16,345.00 8 Walker -$4,500.00 -$1,660.00 -$6,160.00 9 Grand Total -$14,150.00 $17,420.00 $17,735.00 $19,305.00 10 11 12 13 Classification YES 14 15 Associate 16 Manager 17 Representative 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 3 . 1 2 3 1 4 5 5 7 3 3 ...Text Import Sheet1 Subtotals Sort&Filter Pivot Sheet3 org data 1 2) 10 pts. Use the Adv Filter sheet and build and advanced filter that finds associates that have made more that $1500 2 3 4 5 Instructions org data Adv Filter + A File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments AutoSum 2 Calibri 11 AA == General Normal Bad YX AY FO X Cut LECopy Paste Format Painter Clipboard 2 Wrap Text Merge & Center BIU CA $ %, 8 Neutral Insert Delete Format Clear Conditional Format as Good Formatting Table Styles Sort & Find & Filter Select Editing Analyze Data Font Alignment Number Cells Analysis B1 fic H 1 J L M N O P Q R S T U A B D E F 1 2 3 Name Email Address Classification Location Goal Actual Difference 4 Natasha Ari n.ari@somewhwere Associate Baudette 4500 4095 -4500 5 Mikayla Anderson m.anderson@somewhwere Representative Baudette 17000 9350 -2400 6 Ella Jamison e.jamison@somewhwere Manager Baudette 15000 13200 -750 7 David Gazik d.gazik@somewhwere Manager Baudette 15000 13200 -8225 8 BJ Francine bj.francine@somewhwere Representative Baudette 17000 17680 -405 9 Ari Aronson a.aronson@somewhwere Associate Baudette 4500 4095 -5600 10 Alec Mikayla a.mikayla@somewhwere Representative Baudette 17000 19350 -750 11 Suzanne Ouimet s.Ouimet@somewhwere Manager Breezy Point 15000 14250 -1700 12 Sharon Wyatte s.wyatte@somewhwere Manager Breezy Point 15000 14250 -1800 13 Kendra Shelton k.shelton@somewhwere Representative Breezy Point 18000 13500 800 14 Kendal Shaedon k.shaedon@somewhwere Representative Breezy Point 18000 13500 2350 15 Frankie Dennis f.dennis@somewhwere Representative Breezy Point 18000 15660 -2250 16 DJ Bushman dj.bushman@somewhwere Representative Breezy Point 17000 17680 -2250 17 Dennis Frankie d.frankie@somewhwere Representative Breezy Point 18000 19660 680 18 Randy Josephson r.josephson@somewhwere Associate Cass Lake 5000 3300 -2250 19 Mae Gomez m.gomez@somewhwere Representative Cass Lake 17500 13300 -4200 20 Jeffery Dalton j.dalton@somewhwere Manager Cass Lake 15000 12750 -1700 21 Corey Daniels c.daniels@somewhwere Associate Cass Lake 5000 3300 -1800 22 Christopher Bowman c.bowman@somewhwere Manager Cass Lake 15000 12750 -405 23 Christopher Bowman c.bowman@somewhwere Manager Cass Lake 15000 12750 1660 24 Chad Mei c.mei@somewhwere Representative Cass Lake 17500 18300 -7650 25 Tammy Christine t.christine@somewhwere Representative Walker 17500 9275 -2340 26 Nikolai Jalowiec n.jalowiec@somewhwere Manager Walker 15000 12600 -4500 27 Josie Daddiline j.daddiline@somewhwere Representative Walker 17500 11900 680 28 29 30 31 32 33 34 35 Instructions Adv Filter + org data 100% File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Corbel 11 AA == ab Wrap Text General DA Normal Bad N TIX AY X Cut L6 Copy & Format Painter Fill Paste BIU MA IEEE 2 Merge & Center $ % Neutral Insert Delete Format Conditional Format as Good Formatting Table Clear Sort & Find & Filter Select Editing @ Analyze Data Analysis Clipboard Font Alignment Number Styles Cells 010 X f F G H J L M N 0 P Q s T U V w Y Z 1 2 3 4 Criteria Area Classification Location 5 Name Category Amount 6 7 8 9 10 11 12 13 Results or Extract Area 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Instructions org data Adv Filter + 1) 15 pts. Use the "org data" to build a Pivot table on a separate Sheet Called "Pivot Org" provide Slicers and Dynamic Chart It should look like this: H J K L - Sum of Difference $0.00 Bree Point Lake w -$2,000.00 -16.000.00 1 1 -36,000.00 Classification - Associate - Manager Representative 2 -$8.000.00 3 $10.000 1 -$12,000.00 $ -$14,000.00 5 5 Location - 7 D E 1 2 3 Sum of Difference Column Labels 4 Row Labels Associate Manager Representative Grand Total 5 Baudette -$10,100.00 $8,975.00 -$3,555.00 $22,630.00 6 Breezy Point -$3,500.00 -$670.00 $4,170.00 7 Cass Lake -$4,050.00 -$445.00 -$11,850.00 $16,345.00 8 Walker -$4,500.00 -$1,660.00 -$6,160.00 9 Grand Total -$14,150.00 $17,420.00 $17,735.00 $19,305.00 10 11 12 13 Classification YES 14 15 Associate 16 Manager 17 Representative 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 3 . 1 2 3 1 4 5 5 7 3 3 ...Text Import Sheet1 Subtotals Sort&Filter Pivot Sheet3 org data 1 2) 10 pts. Use the Adv Filter sheet and build and advanced filter that finds associates that have made more that $1500 2 3 4 5 Instructions org data Adv Filter + A File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments AutoSum 2 Calibri 11 AA == General Normal Bad YX AY FO X Cut LECopy Paste Format Painter Clipboard 2 Wrap Text Merge & Center BIU CA $ %, 8 Neutral Insert Delete Format Clear Conditional Format as Good Formatting Table Styles Sort & Find & Filter Select Editing Analyze Data Font Alignment Number Cells Analysis B1 fic H 1 J L M N O P Q R S T U A B D E F 1 2 3 Name Email Address Classification Location Goal Actual Difference 4 Natasha Ari n.ari@somewhwere Associate Baudette 4500 4095 -4500 5 Mikayla Anderson m.anderson@somewhwere Representative Baudette 17000 9350 -2400 6 Ella Jamison e.jamison@somewhwere Manager Baudette 15000 13200 -750 7 David Gazik d.gazik@somewhwere Manager Baudette 15000 13200 -8225 8 BJ Francine bj.francine@somewhwere Representative Baudette 17000 17680 -405 9 Ari Aronson a.aronson@somewhwere Associate Baudette 4500 4095 -5600 10 Alec Mikayla a.mikayla@somewhwere Representative Baudette 17000 19350 -750 11 Suzanne Ouimet s.Ouimet@somewhwere Manager Breezy Point 15000 14250 -1700 12 Sharon Wyatte s.wyatte@somewhwere Manager Breezy Point 15000 14250 -1800 13 Kendra Shelton k.shelton@somewhwere Representative Breezy Point 18000 13500 800 14 Kendal Shaedon k.shaedon@somewhwere Representative Breezy Point 18000 13500 2350 15 Frankie Dennis f.dennis@somewhwere Representative Breezy Point 18000 15660 -2250 16 DJ Bushman dj.bushman@somewhwere Representative Breezy Point 17000 17680 -2250 17 Dennis Frankie d.frankie@somewhwere Representative Breezy Point 18000 19660 680 18 Randy Josephson r.josephson@somewhwere Associate Cass Lake 5000 3300 -2250 19 Mae Gomez m.gomez@somewhwere Representative Cass Lake 17500 13300 -4200 20 Jeffery Dalton j.dalton@somewhwere Manager Cass Lake 15000 12750 -1700 21 Corey Daniels c.daniels@somewhwere Associate Cass Lake 5000 3300 -1800 22 Christopher Bowman c.bowman@somewhwere Manager Cass Lake 15000 12750 -405 23 Christopher Bowman c.bowman@somewhwere Manager Cass Lake 15000 12750 1660 24 Chad Mei c.mei@somewhwere Representative Cass Lake 17500 18300 -7650 25 Tammy Christine t.christine@somewhwere Representative Walker 17500 9275 -2340 26 Nikolai Jalowiec n.jalowiec@somewhwere Manager Walker 15000 12600 -4500 27 Josie Daddiline j.daddiline@somewhwere Representative Walker 17500 11900 680 28 29 30 31 32 33 34 35 Instructions Adv Filter + org data 100% File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Corbel 11 AA == ab Wrap Text General DA Normal Bad N TIX AY X Cut L6 Copy & Format Painter Fill Paste BIU MA IEEE 2 Merge & Center $ % Neutral Insert Delete Format Conditional Format as Good Formatting Table Clear Sort & Find & Filter Select Editing @ Analyze Data Analysis Clipboard Font Alignment Number Styles Cells 010 X f F G H J L M N 0 P Q s T U V w Y Z 1 2 3 4 Criteria Area Classification Location 5 Name Category Amount 6 7 8 9 10 11 12 13 Results or Extract Area 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Instructions org data Adv Filter +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Table Tools cel_CHOS_ML2_Fiesta Collection Instructions - Saved References Mailings Review View Help Design Layout Search Points Possible Step Instructions Start Excel. Download and open the file...

Project General Information and Background In this project you are working with cost and financial information for a small computer manufacturer. The company manufacturers only two premium computers....

Product Costs Worksheet: Step 1: Use the "Part Number" as the reference and V look-up function to bring the "Cost per Component" information from the "Inventory Master File" worksheet. For reference...

Having discussed the question of outsourcing versus in-house solutions for Dirt Bikes, in the Dirt Bikes case study, it is time for you to come to your own conclusions. Address the questions below...

Management has asked for a briefing on what is involved in making this decision. They need to understand several things: What is needed to implement such a system as an infrastructure investment, and...

Could you please help me with the assignment? The instructions, marking rubric and statistics are in the folders. Thank you. ACC ACF 2400 - Semester 2, 2017 Individual Assignment 1: Building a...

Which type of Medical Service (type 1, type 2 etc.) brought the most revenue in Birmingham? In addition to the pivot table, provide a pie chart that displays the total amount billed by the different...

Product Costs Worksheet: Step 1: Use the Part Number as the reference and V look-up function to bring the Cost per Component information from the Inventory Master File worksheet. For reference on how...

During 2016, Chung Corporation earned $8,000 of cash revenue and accrued $5,000 of salaries expense. Required Based on this information alone: a. Prepare the December 31, 2016, balance sheet. b....

A cargo ship can carry a maximum weight of 200,000 pounds. The cargo is packaged in 5,000-pound containers on the ship. The total cargo weight is a function of the number of containers on the ship....

The of the option is the stock. price minus exercise price, or the proft that could be attained by immediate exercise of an in the - money call option. intrinsic value time value stabed value...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...