Find the largest section
Which section has the most points available? Use the points in B2:B6 and the names in A2:A6.
Formula: =INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0)) → Formulas
Hands-on Excel exercises
Excel Tests and Job Skills Practice
One starting point for Excel hiring tests: a live scoring sheet, worked answers, and links to level, interview, and role practice pages.
Employers rarely use the same Excel test twice. One sends a timed quiz, another emails a workbook with a deadline, and a third asks you to share your screen and fix a report while someone watches. What they usually have in common is a short list of fundamentals: totals, conditions, lookups, cleanup, and a summary you can explain. This page is the starting point for practicing those fundamentals before you pick a narrower page.
If formulas are still new, open the basic skills test practice first. If you already use SUMIFS and VLOOKUP at work, try the intermediate and advanced pages to find your gaps, or jump to the page for your role: accountants, financial analysts, data analysts, administrative assistants, HR, marketing, project managers, sales operations, or students. The interview pages cover the spoken side, including common questions with short answers. The MO-200 and MO-201 pages are independent skill practice for those exams.
The sheet below models a practice scorecard: five test sections with points available and points earned. It is a small example of the check you should run on any answer, because a result is only useful if you can say what it should be. Complete the task, change a score, and watch the percentage move. Then use the worked answers to find the largest section and count where you lost the most points.
Your turn
Your turn: in F2, calculate the percent of available points earned across all five sections, rounded to a whole number.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Section | Points available | Points earned | |||
| 2 | Formulas | 30 | 24 | |||
| 3 | Lookups | 20 | 14 | |||
| 4 | Cleanup | 20 | 16 | |||
| 5 | Summary | 20 | 12 | |||
| 6 | Charts | 10 | 9 |
Not yet solved.
Answer: =ROUND(SUM(C2:C6)/SUM(B2:B6)*100,0)
Practice under a time limit
Try the free Sample mock exam with 4 tasks in 8 minutes, or browse the level and interview mock exams included with Pro + Exams.
Related exercises
Open a task in its lesson.
- In C7, calculate how many items were bought in total.
- In C2:C8, write "Pass" if the score is at least the passing score (F1), otherwise "Fail".
- In F2, calculate the total of Emma's deals in Boston.
- In G2:G4, look up the item price.
- In G2:G6, turn the text in column A into numbers (some have spaces at the edges).
- Build a second PivotTable: the average deal amount by city, with the result in F8.
- In F10:F13, find the prepayment discount from the scale in F2:G5 (approximate match on the number of months).
- Fix D3: the average price of coffee.
Worked answers
Try the spreadsheet first, then compare your formula and result.
Count sections that lost more than 5 points
In how many sections is the gap between available and earned points larger than 5?
Formula: =SUMPRODUCT((B2:B6-C2:C6>5)*1) → 3
Frequently asked questions
Which page should I open first?
Pick by your situation: the basic page if formulas are new, the interview pages if you have a conversation coming up, or your role page if you know the job. Each one links to the others.
Is there a timed option?
Yes. The free Sample mock exam has 4 tasks in 8 minutes and draws only from free lessons. The level and interview mock exams are part of Pro + Exams.
Will this match my employer's test?
No practice page can match a specific test. These pages build the fundamentals most spreadsheet tests rely on; read your own instructions for the exact format.
Do I need to install anything?
No. The live sheet and the linked lesson tasks run in your browser.