Test: Pivot Table - 2 - Class 6 MCQ

By selecting the Pivot Table and choosing a different style from the "Styles" dropdown in the toolbar.

By selecting the Pivot Table and right-clicking to open a context menu, then choosing a different style.

By selecting the Pivot Table and choosing the "Customize Appearance" option from the right-click context menu.

By selecting the Pivot Table and pressing the "Ctrl+A" shortcut key combination.

It allows you to display or hide the grand total row/column in the Pivot Table.

It allows you to change the layout and formatting of the Pivot Table.

It allows you to filter the data in the Pivot Table based on specific criteria.

It allows you to perform mathematical calculations on the data in the Pivot Table.

Pivot Tables allow you to create formulas.

Pivot Tables can only be created from the existing data.

Pivot Tables are used to create charts in MS Excel.

Pivot Tables cannot handle large datasets.

To create macros in MS Excel.

To perform advanced statistical analysis.

To summarize and analyze large datasets.

To format data in MS Excel.

Excel Tables

CSV files

SQL databases

PDF documents

To group similar values together.

To apply filters to the Pivot Table.

To perform calculations on the data.

To change the appearance of the Pivot Table.

Calculated fields allow you to add new columns to the data source.

Calculated fields can only be created using VBA macros.

Calculated fields can be used to perform advanced statistical calculations.

Calculated fields are used to filter the data in Pivot Tables.

To change the data source of the Pivot Table.

To add conditional formatting to the Pivot Table.

To filter data in the Pivot Table visually.

To create charts from the Pivot Table.

Pivot Charts are only available in MS Excel for Mac.

Pivot Charts cannot be modified once created.

Pivot Charts are automatically updated when the Pivot Table changes.

Pivot Charts can only be created from raw data, not from a Pivot Table.

To apply conditional formatting to the Pivot Table.

To change the data source of the Pivot Table.

To add multiple layers of filtering to the Pivot Table.

To sort the data in the Pivot Table.

Sum

Average

Max

Mode

Grouping can only be applied to date fields.

Grouping is a one-time operation and cannot be undone.

Grouping allows you to merge cells in a Pivot Table.

Grouping can be used to create hierarchical data in a Pivot Table.

By selecting the Pivot Table and pressing F2.

By right-clicking on the Pivot Table and selecting "Refresh".

By closing and reopening the Excel file.

By copying and pasting the data again.

Pivot Table styles cannot be customized.

Pivot Table styles are applied automatically based on the data.

Pivot Table styles can be modified using VBA macros.

Pivot Table styles are only available in the online version of MS Excel.

To group similar values together.

To apply filters to the Pivot Table.

To perform calculations on the data.

To create rows in the Pivot Table.