Learn: Pivot Tables
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 11 steps including 4 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (11)
Match the items on the left with their correct pairs on the right
Match the items on the left with their correct pairs on the right
What is the main purpose of a pivot table?
Start the lesson to answer this multiple choice question
Match the items on the left with their correct pairs on the right
In a pivot table, the {{blank0}} field determines the categories, while the {{blank1}} field is summarised using functions like SUM or COUNT.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
Match the items on the left with their correct pairs on the right
Which of the following are benefits of pivot tables? (Select all that apply)
Start the lesson to answer this multi-select question
Match the items on the left with their correct pairs on the right
Match the items on the left with their correct pairs on the right
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics