12 questions to validate formulas & conditional formatting: editor and syntaxes, conditional formatting, running totals, functions and If/Select logic, advanced groups.
Answer everything, then click Check: your score and explanations will appear.
3.1 · Recall
1. Where do you create a calculated value (total incl. tax, margin) and in which default syntax?
Formula = manufactured field in the editor, checked and typed.
3.1 · Application
2. Farès wants the 19% total incl. tax and the full name in Crystal syntax. He writes…
Field inserted from the list, operator, literal — then check.
3.2 · Recall
3. How does a font color become conditional (negatives in red)?
One formula per property, evaluated row by row.
3.2 · Application
4. Farès wants to highlight stock below 10 in yellow (cell background). He writes…
Background to highlight, color returned for a color.
3.3 · Application
5. Farès wants to see the balance rise row after row (statement), not just the final total. He uses…
Row-by-row progression = running total; final synthesis = summary.
3.3 · Application
6. Farès wants a running balance restarting from zero per customer. He sets…
Per-group reset = balance per customer; sort first.
3.4 · Recall
7. To translate ONE code into labels (A → Active, S → Suspended), the most readable tool is…
One value, fixed cases: Select…Case.
3.4 · Application
8. Farès segments his customers by revenue and computes a null-protected delay. He writes…
Thresholds → chained Ifs; doubtful field → IsNull first.
3.5 · Application
9. Farès prepares the Top 10 customers: his report is grouped by customer. He still needs…
Group + subtotal first: no criterion, no ranking.
3.2 · Arbitration
10. A report piles up seven conditional colors, red = good here and bad there. Correct call?
Flag, don't decorate: restraint and a constant code.
3.4 · Arbitration
11. A formula fails intermittently on some records (sometimes-empty date). Correct call?
IsNull first: no null crosses the formula.
3.5 · Arbitration
12. Management switches off in front of 200 alphabetical customers; the essentials are needed in thirty seconds. Correct call?
Ranked leaderboard on page one, detail after.
What's next?
Score ≥ 80%: move to Level 4 — subreports, charts, crosstabs and multi-sources (combining what joins alone cannot do).
Score 50-79%: revisit the failed sections (syntaxes in 3.1, x-2 button in 3.2, Reset in 3.3, If/Select and IsNull in 3.4, Top N in 3.5) then retake the test.
Score < 50%: replay each 48h challenge in order — 2 formulas, 2 colors, 1 running statement, 1 band formula, 1 ranking page.