Session 2 : Excel Data Analysis Tools Quiz

What is the purpose of using PivotTables in Excel?

• To sort data

• To format text

• To simplify large dataset interpretation

• To create charts

Which menu option do you select to create a PivotTable?

• Data > Filter

• Insert > PivotTable

• Home > Format

• View > Charts

What is the first step in using filters in Excel?

• Go to Data > Subtotal

• Select the header row

• Insert a chart

• Highlight the data range

What function is used to get subtotals in Excel?

• =AVERAGE()

• =COUNT()

• =SUM()

• =SUBTOTAL()

Which of the following is a real-life example of using a PivotTable?

• Creating a dynamic sales dashboard

• Highlighting top-performing sales reps

• Summarizing monthly sales by region

• Filtering products with sales above RM10,000

What is the first step in grouping data in Excel?

• Insert a chart

• Select rows/columns

• Go to Data > Group

• Sort your data

What does the Quick Analysis Tool allow you to do?

• Group data

• Sort data

• Create PivotTables

• Quickly highlight top values

Which option is used to create charts from a PivotTable?

• Insert > Recommended Charts

• View > Slicer

• Data > Filter

• Home > Format

What is the purpose of conditional formatting in Excel?

• To create charts

• To highlight specific data

• To sort data

• To group data

What is the first step in building a dashboard in Excel?

• Combine multiple elements

• Insert a Slicer

• Clean formatting

• Add interactive elements