alunedes File Home Insert Draw Page Layout Formulas Data Review View Help Oslibri 14 - A A OA == General Pasta BLU- 25 Wrap test Murge & Center int- Delete EM $ - % *38-98 Cipboard Conditional Format as Cell Formatting Table Styles Styles Format Font Alignment Number H7 Cells G O M N (20pts) Make a Pivot Table in a new sheet. Answer the following questions based off the pivot table. Enter your answers in the yellow cell. 1 Region East 1 Central Central 5 Central West East Central Central 10 West 11 Last Central 1. Which rep had the highest sales total? 2. Which item was sold the most? C D Rep Item Units Unit Cost Total ons Pencil 95 $ 1995 189.05 Kivell Binder 50 S 19.99 $ 999.50 Jardine Pencil 36 S 4.995 179.64 Gill Pen 27 S 19.99 $ 539.73 Solving Pencil 56 5 2.99 167.44 Jones Binder 50 S 4.99 $ 299.40 Andrews Pencil 75 S 1.99 $ 1:49.25 Lardino Pencil 90 S 4.995 449.10 Thompson Pencil 32S 1995 63.68 Jones Binder 60 S 8.99 $ 539.40 Morgan Pencil 90 $ 4.995 449.19 Howard Finder 29 s 1.99S 57.71 Parent Hinder 81 S 19.99 $ 1,619.19 lones Penca 35 5 4.99 S 174.65 Seth Desk 2 $ 125.00 S 250.00 Jones Pen Set 16 S 15.99 $ 255.84 More 28 $ 8.095 251.72 Jones 54 5 8.99 $ 575.36 Parent Pen 15 S 19.99 $ 299 85 965 4.99 $ 479,04 Smith Pencil 67 S 1.295 86.43 Pe Set 15.99 $ 1.183.26 1214 5 6 de ENTER Choose 3. Which region had the highest sales total? 14 Cast 4. How many total units of Pencil were sold? Central 11 East Cemal 19. El 20 E 21 Central 5. Which rep in the East Region grossed the most from the sale of pens? 145 Type here to search O