Welcome to this quiz on how to create a basic pivot table.
Checkout the Resources listing and you’ll find some resources; download the Excel workbook and carry out the instructions. Once you have completed the requirements, please answer the questions in the quiz.
Pass Mark to continue to next lesson: N/A
Time limit: N/A
0 of 7 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 7 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
You scored below the recommended pass mark of 80%. Please review the answers and make sure you understand where you went wrong. When you’re comfortable with the material, continue to the next lesson.
Congratulations you have attained the recommended pass mark of 80%.
Please continue to the next lesson.
What are the advantages of summarising a dataset using a pivot table?
What is the alternative to summarising datasets using a pivot table?
Which tab do you need to select to create a pivot table?
Once you have selected the correct tab, which of the following options on the ribbon could you select to create a pivot table?
Using the pivot table created from the resources, what was the total profit generated in 2017?
Using the pivot table created from the resources, what was the total Profit generated in the Mid Tier segment in 2016?
What is the Field list?