Level 0 exam — Microsoft Excel

Exam — fresh questions

12 questions to validate getting started with Wassim: what Excel is for, accessing it for free, finding your way in the interface, and entering data without loss.
Answer everything, then click Check: your score and explanations will appear.

0.1 · Recall

1. What is Excel's real strength over a calculator?

It prints faster Formulas and automatic recalculation when data changes Nothing special It looks nicer

A cell can depend on others via a formula; Excel recalculates everything automatically — that is the spreadsheet principle.

0.1 · Application

2. Wassim changes his rent from 800 to 900 and his total =SUM(B2:B3) goes by itself from 1200 to 1300. What does this test prove?

That the total was typed hard-coded That the file is corrupted That the printer works That automatic recalculation works: the total depends on the amounts

B4 contains a formula that depends on B2:B3: changing data updates the result without retyping.

0.1 · Arbitration

3. A colleague wants to handle millions of rows with simultaneous entries in Excel. Wassim's verdict?

Refuse: Excel is not a calculator Refuse: at that scale you switch to a database or Power BI Accept: Excel handles everything, just add rows Accept if you hide columns

Excel excels on medium-sized tables; for very large volumes or transactional work, DB or Power BI.

0.2 · Recall

4. Wassim is starting out with no budget. What does he choose to learn?

A random unknown spreadsheet Only the mobile app Nothing: Excel is necessarily paid Excel for the web, free with a Microsoft account

Excel for the web is free and covers the essentials up to intermediate; desktop will come for advanced Power Query and macros.

0.2 · Application

5. Wassim wants to prepare advanced Power Query and macros. Which version does he need?

Excel desktop (Microsoft 365), because macros and advanced depth are reserved for it Excel mobile is enough The free web is always enough The old .xls format is enough

Macros and Power Query in full depth are reserved for the desktop app.

0.2 · Application

6. Wassim creates his workbook on the web then opens it on desktop. Why does the swap work?

Because the .xlsx format is standard and readable on both sides Because .csv keeps formulas Because mobile converts everything Because everything is printed

The .xlsx is the standard format: same workbook on the web and desktop, via OneDrive or download.

0.3 · Recall

7. What does the address « C5 » mean?

A range of 5 cells Column 5, row C Column C, row 5 The 5th sheet

Address = column letter + row number: C5 = column C, row 5.

0.3 · Application

8. In his Summary sheet, Wassim writes =SUM(Data!D2:D200). What does this formula read?

The range D to 2 The range D2:D200 of the sheet named « Data » A syntax error The 2nd data of the workbook

The « ! » separates the sheet name from the address: the formula reads a range on ANOTHER sheet of the same workbook.

0.3 · Arbitration

9. Wassim's workbook mixes everything onto « Sheet1 » and a displayed total seems wrong. What does he start with?

Saving as .csv Deleting the workbook Retyping everything hard-coded Renaming the sheets, separating data and summary, then checking the formula bar

Named sheets + data/summary separation + formula bar to see whether the total is a formula.

0.4 · Recall

10. How do you confirm an entry by moving to the cell on the RIGHT?

Esc Delete Tab Enter

Tab confirms and goes right; Enter confirms and moves down one cell.

0.4 · Application

11. Wassim's amounts align left and =SUM(B2:B10) returns 0. Most likely cause?

Excel is broken The cells are locked The numbers are stored as text The range is empty

A left-aligned number is actually text: SUM ignores it. You retype it as a number or convert it.

0.4 · Arbitration

12. Wassim must save his budget with formulas and formatting. Which format does he settle on?

The .xlsx, because .csv keeps only raw values without formulas or formatting The .csv, because it keeps everything None: the web never saves An old .xls

.csv = raw values only; .xlsx = standard that keeps formulas and formatting, auto on the web.

What's next?

Score ≥ 80%: move on to Level 1 — formulas, addressing and functions with Wassim.
Score between 50% and 80%: redo the failed section(s) (0.1 usage, 0.2 access, 0.3 interface, 0.4 gestures), reread the explanations above, then retake the test.
Score < 50%: reread all of level 0 while applying each 48h challenge (Excel case, web workbook, three-sheet plan, enter-confirm-save loop) before retrying.
And after? Keep Wassim's workbook plan and basic-gesture memo: level 1 replays them on real formulas.