Quiz

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
BartoszCreated by Bartosz
10 Steps8 Questions

Students also studied

Browse all

Steps in this lesson (10)

1
Text

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.

2
Multiple ChoiceInteractive

What is a pivot table primarily used for?

Start the lesson to answer this multiple choice question

3
Fill in the BlankInteractive

A {{blank0}} table allows users to reorganise and summarise data in a spreadsheet.

Start the lesson to answer this fill in the blank question

4
MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

5
Multi-SelectInteractive

Which of the following are true about pivot tables? (Select all that apply)

Start the lesson to answer this multi-select question

6
Multiple ChoiceInteractive

Which of these fields in a pivot table is used to summarise data values?

Start the lesson to answer this multiple choice question

7
typedAnswer

Match the items on the left with their correct pairs on the right

8
Fill in the BlankInteractive

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

9
Multiple ChoiceInteractive

Which type of data is best suited for analysis with a pivot table?

Start the lesson to answer this multiple choice question

10
Multi-SelectInteractive

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