BTEC Digital Information Technology MCQ Quiz

What is the main purpose of a Pivot Table?

• To sort data alphabetically

• To filter data permanently

• To summarise and analyse large data sets

• To create bar charts

Which feature allows you to filter data interactively in a Pivot Table?

• Filter Row

• Slicer

• Sort Button

• Conditional Formatting

What is a Pivot Chart?

• A chart linked to a Pivot Table that updates automatically

• A simple bar chart

• A type of scatter graph

• A static diagram

Which element can you add to a chart to show what each colour represents?

• Axis Title

• Legend

How can you change the appearance of a pivot chart’s data based on conditions?

• Use Data Validation

• Use Conditional Formatting

• Use Slicers

• Use Filters

What symbol does every formula start with in Excel?

• $

• @

• &

• =

What is the benefit of using Slicers in a Pivot Table?

• They permanently delete rows

• They visually filter data easily

• They export data to PDF

• They print charts

Q8: The icon that lets you add chart elements like titles and labels is:

• the Chart Elements icon (plus sign)

• the Filter icon (funnel)

• the Chart Styles icon (paintbrush)

• the Data Table icon

What type of formatting highlights data automatically based on rules?

• Manual Formatting

• Conditional Formatting

• Pivot Formatting

• Chart Formatting

If you use =COUNTIF(A1:A20, ">10"), what does it do?

• Counts all numbers equal to 10

• Counts cells greater than 10

• Adds up numbers greater than 10

• Filters numbers equal to 10