Quiz: Pivot Tables
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 10 steps including 8 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (10)
Building on what you've already learned about spreadsheets, let's test your knowledge of pivot tables! This will help you understand how to summarise and analyse data effectively.
What is a pivot table primarily used for?
Start the lesson to answer this multiple choice question
A {{blank0}} table allows users to reorganise and summarise data in a spreadsheet.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
Which of the following are true about pivot tables? (Select all that apply)
Start the lesson to answer this multi-select question
Which of these fields in a pivot table is used to summarise data values?
Start the lesson to answer this multiple choice question
Match the items on the left with their correct pairs on the right
The {{blank0}} field in a pivot table helps narrow down the data shown by applying specific criteria.
Start the lesson to answer this fill in the blank question
Which type of data is best suited for analysis with a pivot table?
Start the lesson to answer this multiple choice question
Which actions can you perform using a pivot table? (Select all that apply)
Start the lesson to answer this multi-select question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics