If you were to create a Microsoft Excel pivot table for the following data set,
ID: 3198918 • Letter: I
Question
If you were to create a Microsoft Excel pivot table for the following data set, which of the following statements is true? Sales S 372.6!5 Lovalty ID Zip Code Gender Item Sold 2000101 33312 Female Beauty 2000102 33317 Female Beauty $ 220.03 200010333314 Male 2000104 33316 Female Diet & Supp $ 1,213.02 200010533313 Female Diet & Supp S 163.47 200010633315 Female Food 2000107 33311 Female Food Baby SupplyS 247.84 $5.35 S 673.05 The pivot table could be created in a separate worksheet Four fields are available for creating the pivot table It is useful to move Sales into Row Label box It is useful to move Zip Code into Values box All of the aboveExplanation / Answer
All of the above are cocorrect......
The pivot table could be created in a seperate worksheet
Four fields are available for creating the pivot table
It is useful to move sales in row label box
It usefu to move zip code into values box