12 questions to validate level 3: pivot tables, charts suited to the message, slicers and dashboards, data validation, exact conditional calculation.
Answer everything, then click Check: your score and explanations will appear.
3.1 · Recall
1. In a pivot table, where do you drag the field you want to add or average?
The Values area holds the aggregate; Rows/Columns hold the categories, Filters the scope.
3.1 · Application
2. Wassim wants the total sales by region from 4,000 rows, without writing a formula. What does he do?
The pivot table summarizes by drag-and-drop: Region in Rows, Sum of Amount in Values — no formula needed.
3.2 · Recall
3. To show the revenue trend over 12 months, which chart to choose?
A trend over time reads on a line; pies serve breakdowns, columns serve comparisons.
3.2 · Arbitration
4. A colleague presents 12 regions as a pie and adds 3D effects «to convince». Your arbitration?
Beyond 5 parts the pie is illegible; the decoration drowns the message — a good chart reads in 3 seconds.
3.2 · Application
5. Wassim filters his pivot table on Algiers and wants the visual to follow by itself. Which tool?
The pivot chart is linked to the pivot table: it follows its filters and rearrangements, and reacts to slicers.
3.3 · Application
6. Wassim wants one click to filter two pivot tables (sales and margins) plus their charts. What does he set up?
The slicer is a visual filter; via the report connections, it drives several pivot tables simultaneously.
3.3 · Recall
7. What is the difference between a slicer and a timeline?
Both visually filter a pivot table; the timeline is dedicated to dates (month/quarter/year) via a slider.
3.4 · Application
8. Wassim's Region column contains «alger», «Alger» and «ALGER». What does he set up?
The drop-down list closes the choices: you select instead of typing, and the structured source makes it scalable.
3.4 · Arbitration
9. For critical amounts, a colleague judges validation «100% sufficient». Your arbitration?
Validation protects only manual entry: on critical data, you add an a posteriori check of the anomalies.
3.5 · Application
10. Wassim wants the total of Algiers sales. Which exact formula?
SUMIF adds the amounts whose region equals Algiers: (criteria_range, criterion, sum_range).
3.5 · Application
11. In SUMIFS, where does the range to add go?
Classic trap: SUMIF puts the criteria range first, but SUMIFS puts the sum range FIRST.
3.5 · Arbitration
12. Should you freeze the KPIs with SUMIFS or explore everything in the pivot table?
Complementarity: SUMIFS freezes a reusable figure, the pivot table keeps exploration open.
What's next?
Score ≥ 80%: move to Level 4 — advanced functions, formula auditing and automation (making reliable what this level summarizes).
Score 50-79%: revisit the failed sections (refreshing in 3.1, chart choice in 3.2, connections in 3.3, lists in 3.4, ...IFS order in 3.5) then retake the test.
Score < 50%: replay each 48h challenge in order — refreshed pivot table, linked chart, synchronized dashboard, set list, verified KPIs.