Question: For the provided dataset, create Named Ranges and convert data into a Table. Add a row displaying averages for each of the quantitative variables. Provide
For the provided dataset, create Named Ranges and convert data into a Table. Add a row displaying averages for each of the quantitative variables. Provide a screenshot that shows the averages you have calculated. Insert Slicers for Region and Product Category. Personalise your Table and Slicer designs. Filter your Table and Slicers to display only your assigned Region and Product Category, as shown in the table below. Provide a screenshot that shows your Table and Slicers. Include your student number in the screenshot. Student ID Last Digit Region Product Category WA Sports SA Sports QLD Fashion SA Electronics VIC Beauty QLD Beauty QLD Sports WA Fashion QLD Electronics SA Homewares
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
