1. A PivotTable in Excel is mainly used for:
(A) Entering data
(B) Summarizing and analyzing large amounts of data
(C) Formatting worksheets
(D) Drawing diagrams
2. Which tab in Excel contains the option to insert a PivotTable?
(A) Insert
(B) Home
(C) Data
(D) Review
3. In a PivotTable, the field that goes into the “Values” area is usually used for:
(A) Titles
(B) Calculations (Sum, Count, Average, etc.)
(C) Filtering records
(D) Category names
4. Which area of a PivotTable is used to categorize data horizontally?
(A) Values Area
(B) Filters Area
(C) Columns Area
(D) Rows Area
5. Which area of a PivotTable is used to categorize data vertically?
(A) Values Area
(B) Filters Area
(C) Columns Area
(D) Rows Area
6. Which option allows you to filter data in a PivotTable without altering the original data source?
(A) PivotChart
(B) Slicer
(C) Format Painter
(D) Grouping
7. In a PivotTable, the “Grand Total” row or column displays:
(A) Only maximum values
(B) Only averages
(C) The total of all values in that row or column
(D) The smallest values
8. PivotCharts in Excel are used to:
(A) Create random charts
(B) Generate passwords
(C) Format worksheet cells
(D) Visually represent PivotTable data
9. When the source data of a PivotTable changes, what must you do to update the PivotTable?
(A) Recreate the PivotTable
(B) Refresh the PivotTable
(C) Save the file again
(D) Insert a new chart
10. Which of the following is NOT true about PivotTables?
(A) They can summarize large datasets
(B) They can create custom calculations
(C) They permanently alter the original dataset
(D) They allow grouping and filtering