Order PDF of any content from our website with a little minor Fee to donate for hard work. 
For details: contact whatsapp +923028700085
Important notes based PDF Books are available in very little price, starting from 500/-PKR;
Order Now:  contact whatsapp +923028700085

Pivot Tables and Pivot Charts MCQs

10 Score: 0 Attempted: 0/10
1. A PivotTable in Excel is mainly used for:




2. Which tab in Excel contains the option to insert a PivotTable?




3. In a PivotTable, the field that goes into the “Values” area is usually used for:




4. Which area of a PivotTable is used to categorize data horizontally?




5. Which area of a PivotTable is used to categorize data vertically?




6. Which option allows you to filter data in a PivotTable without altering the original data source?




7. In a PivotTable, the “Grand Total” row or column displays:




8. PivotCharts in Excel are used to:




9. When the source data of a PivotTable changes, what must you do to update the PivotTable?




10. Which of the following is NOT true about PivotTables?




All Copyrights Reserved 2025 Reserved by T4Tutorials