12 new questions: recall, application and arbitration on logical functions, lookup, text and dates, conditional formatting and structured tables.
Answer everything, then click Check: your score and explanations will appear.
2.1 · Recall
1. What does =IF(B2>=100000,"To review","OK") return if B2 is 45000?
The test 45000>=100000 is FALSE: IF returns the value_if_false, "OK".
2.1 · Application
2. Wassim validates an invoice only if the amount is checked (B2>=100000) AND the document received (C2="received"). Which formula?
AND combines the two conditions in the test of a single IF: all true = validated.
2.1 · Application
3. Wassim ranks four discount brackets. Which writing is the most readable?
IFS unwinds the cases in cascade; the first true wins, so the most restrictive order first and TRUE last.
2.2 · Recall
4. What is the key difference between VLOOKUP and XLOOKUP?
VLOOKUP imposes the key in the 1st column and a number to the right; XLOOKUP frees itself from order and handles the not-found case.
2.2 · Application
5. Wassim looks up the rate for the code in A2 in the VATRates table, with a message if absent. Which formula?
XLOOKUP looks up A2 in Code and returns the aligned Rate; the 4th argument replaces #N/A with "To check".
2.2 · Arbitration
6. A colleague's machine (old Excel) has no XLOOKUP. What do you advise Wassim?
INDEX/MATCH is the historic flexible combination: MATCH finds the position, INDEX returns the value.
2.3 · Recall
7. Why does =End-Start give a number of days?
A date is a serial value (day number): the subtraction gives days, to be displayed in Number format.
2.3 · Application
8. Wassim's XLOOKUPs miss "SARL Atlas" (double space, mixed case). What does he do first?
Stray spaces and case make keys fail: clean (TRIM, UPPER/PROPER) before cross-referencing.
2.3 · Arbitration
9. Wassim's computed delay displays "Jan-1900" instead of 12. What do you conclude?
The value (12 days) is correct; only the format lies. A date-calculation result displays as Number.
2.4 · Application
10. Wassim wants to highlight the whole ROW when the actual (C) exceeds the target (D). Which rule?
The TRUE/FALSE formula with the frozen column ($C2, $D2) tests each row and colors the range dynamically.
2.4 · Arbitration
11. Wassim's boss repaints the delays by hand each week. Which argument wins?
CF applies the format according to a living rule; manual color freezes and lies as soon as the data changes.
2.5 · Application
12. Wassim's total =SUM(D2:D200) forgets the 201st invoice. Durable solution?
The frozen range forgets additions; the structured table extends itself and is referenced by name.
What's next?
Score ≥ 80%: move to Level 3 — pivot tables and charts, keeping your reflexes (ordered IFS, named XLOOKUP, cleaned data, living CF, structured tables).
Score 60-79%: revisit the failed sections (2.1 cascades, 2.2 XLOOKUP and 4th argument, 2.3 cleaning and dates, 2.4 formula rule, 2.5 Ctrl+L) and redo the 48h challenges.
Score < 60%: rebuild Wassim's tracker step by step (threshold IF, XLOOKUP of rates, TRIM cleaning, red threshold, Ledger table), then retake the test.
In all cases: keep the reflexes — decide with IF, look up by key, clean before cross-referencing, color by rule, structure into a table.