Question: This is all the info given! Please help 05. Match the Fields used below with the appropriate areas to make this Pivot Table Fruit cup
05. Match the Fields used below with the appropriate areas to make this Pivot Table Fruit cup CO 3 Row Labels Sum of Quantity Sum of Extended Price 4 BIA La Carte 5 $ 7.75 5 Baked Fries 1 $ 0.75 6 Chicken Nuggets 1 $ 2.00 7 1 $ 1.00 Pizza slice 2 $ 4.00 9 Drinks 4 $ 3.75 10 Bottled Water 3 $ 3.00 11 Soda 11 s 0.75 12 Regular Meal 2 $ 4.40 13 Chicken Pie 1 $ 2.20 14 Tacos 1 $ 2.20 15 Snacks 9 $ 6.75 16 Cookies 9 $ 6.75 17 Grand Total 20 $ 22.65 Refer to the PivotTable above: 1. Category (Regular Meal, Snacks, etc.) 2. Item (Pizza Slice, Cookies, Water, etc.) 3. Extended Price (unit price quantity of item sold) 4.Quantity (quantity of item sold) 5. Date (date of the purchase) A. FILTERS or not used, at all B. Second in VALUES C. First in VALUES D. First in ROWS E. Second in ROWS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
