Instructions and covered skills
This test contains 10 multiple-choice questions about pivot tables. Read each question carefully and select the best answer. Ensure you have a basic understanding of pivot table fields, values, filters, and grouping. No external resources are allowed. Turn off notifications and stay focused. You have unlimited time but try to complete it in 15 minutes. Answer all questions to the best of your ability.
Key Areas
- Creating and configuring pivot tables from raw data
- Understanding row, column, value, and filter fields
- Applying number formatting and custom calculations
- Grouping data by dates, numbers, or text
- Using slicers and timelines for interactive filtering
- Sorting and filtering within pivot tables
- Refreshing and updating pivot table data
- Creating calculated fields and items
Recommended Preparation
Familiarity with basic Excel/Google Sheets functions, experience organizing data in tabular format, and prior exposure to pivot table concepts. Practice with sample datasets to solidify understanding of field placements and aggregation methods.