Level 5 exam — Microsoft Excel

Exam — fresh questions

12 fresh questions to validate Specializations & certification: dashboards, scenarios, sharing and MOS.
Answer everything, then click Check: your score and explanations will appear.

5.1 · Recall

1. What is the guiding principle of a good dashboard?

The maximum of colors and 3D effects Message first: few clear KPIs, decluttered visuals, interactivity One chart per column of the file Showing all the available data

A dashboard answers a question at a glance: a few decisive KPIs, decluttered visuals, interactivity.

5.1 · Application

2. Wassim is rebuilding his sales tracking. What do you advise him?

Piling everything onto a single sheet Adding 3D effects to each chart 3 layers: Data, Calculations (pivots, KPIs), Dashboard with a slicer A different file for each chart

Separating Data / Calculations / Dashboard makes the file maintainable and the slicer makes it interactive.

5.1 · Arbitration

3. Management wants « all the figures on one page ». Wassim's arbitration?

Choose 3 to 6 decisive KPIs at the top, the detail on analysis sheets Multiply the colors to fit everything in Delete all the charts Accept and pile everything up to please them

A dashboard reads in a few seconds: few decisive KPIs on the summary page, detail elsewhere.

5.2 · Recall

4. What does Goal Seek do?

It finds the input (one cell) that produces a wanted result It creates a pivot It optimizes several variables under constraints It sorts a table

Goal Seek « reverses » the calculation: from the wanted result to the single input to adjust.

5.2 · Application

5. Wassim looks for the price that zeroes his margin (a single unknown). Which tool?

XLOOKUP Solver A pivot Goal Seek (result = 0, entry = price)

A single unknown and an exact objective: Goal Seek adjusts the price to reach the wanted margin.

5.2 · Arbitration

6. Wassim must allocate a budget between two channels without exceeding the total. Arbitration?

Trying by hand until it works by chance Using Goal Seek on both channels at once Enabling Solver: objective to maximize, variables, total constraint Duplicating the workbook into three versions

Several variables + optimization + constraint: it's Solver, with an objective, variables and written limits.

5.3 · Recall

7. Before protecting a sheet while allowing entry in certain cells, what must you do?

Delete the formulas First unlock the entry cells, then protect Put everything in red Nothing special

Everything is locked by default but the lock only acts after protection: you unlock the entries, then protect.

5.3 · Application

8. Wassim shares his entry model with his team. What does he do?

Deletes the formulas before sharing Emails a copy to each person Protects without unlocking, then emails Saves to OneDrive, link with chosen rights, entries unlocked then sheet protected

A single link with chosen rights + targeted protection: the team enters without breaking the calculations, with no diverging copies.

5.3 · Application

9. A colleague overrode an area of the shared workbook. What does Wassim do?

He disables the cloud sharing He redos the whole file from scratch He blames co-authoring and goes back to emails He restores the previous version via version history

In the cloud, version history is the net: you revert to the earlier state in two clicks.

5.4 · Application

10. How does Wassim best prepare for his MOS Associate (hands-on exam)?

By re-reading a manual the day before By watching a video once By practicing in Excel on the official objectives + a timed mock By revising only the theory

A hands-on exam is prepared by practicing: official objectives, timed files, mock to target.

5.4 · Application

11. After his mock exam, Wassim has two weak areas. What does he do?

He re-reads the whole manual from the start He revises only the gaps detected by the mock He aims directly for the Expert without consolidating He stops practicing

The mock reveals where to revise: you target the gaps instead of rereading everything, Associate first.

5.4 · Arbitration

12. Wassim hesitates: « the cert guarantees a job, no point practicing afterward ». Arbitration?

It validates a recognized level but is worth it combined with real practice It's useless, better to ignore it The MOS replaces all future practice The exact score is promised in advance

The certification attests a recognized level; like any cert, it gains its value with real practice.

What's next?

Score ≥ 80%: move on to Level 6 « In practice » — concrete cases and an Excel toolbox (WITHOUT an exam).
Score 50-79%: re-read the explanations above — each one re-explains the concept — then redo the 48h challenges and the templates of the failed sections (3-layer plan, « what if » sheet, sharing checklist, MOS plan).
Score < 50%: go back to cards 5.1 (dashboard: message first, 3 layers) and 5.3 (sharing: link + targeted protection + versions), your two vital gestures, before continuing.