Apply a reorder rule
Return Reorder if the stock of the item in E2 is below its reorder level, otherwise OK.
Formula: =IF(VLOOKUP(E2,A2:C6,2,FALSE)<VLOOKUP(E2,A2:C6,3,FALSE),"Reorder","OK") → Reorder
Hands-on Excel exercises
Indeed Excel Assessment Practice
Independent practice for Excel skills often screened in hiring: exact lookups, reorder logic, worked answers. Not affiliated with Indeed.
FormulaCamp is not affiliated with Indeed. This is independent practice; it does not reproduce or predict exact Indeed or employer questions.
If a job application sent you an Excel skills assessment through Indeed or an employer's hiring tools, the exact questions are chosen by that employer or provider and can change. FormulaCamp has no access to them and does not reproduce them. What this page offers is independent practice for the general spreadsheet skills such assessments tend to screen: reading a table, looking up a value, applying a simple rule, and summarizing.
The live sheet is a small supplies list with stock on hand and a reorder level for each item. Your task is an exact lookup: return the stock of the item named in E2. The worked answers then apply a rule (should this item be reordered?), count how many items sit below their reorder level, and total the stock. Those three moves, look up, decide, and summarize, cover a surprising share of entry-level office spreadsheet work.
Before you rely on any practice, read the instructions you were given. They state the time limit, the allowed tools, and what the employer wants to see. Use this page to warm up your fundamentals, not to guess questions. A free four-task Sample mock exam is available if you want a timed run, and the Excel assessment test practice page covers cleanup-style tasks.
Your turn
Your turn: in F2, return the stock on hand for the item named in E2, using an exact-match lookup.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Stock | Reorder level | Find item | ||
| 2 | Tape | 40 | 25 | Stapler | ||
| 3 | Stapler | 12 | 15 | |||
| 4 | Folder | 85 | 50 | |||
| 5 | Marker | 18 | 20 | |||
| 6 | Label | 60 | 30 |
Not yet solved.
Answer: =VLOOKUP(E2,A2:C6,2,FALSE)
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 items below their reorder level
How many items have stock below the reorder level on the same row?
Formula: =SUMPRODUCT((B2:B6<C2:C6)*1) → 2
Total stock
What is the total stock across all items?
Formula: =SUM(B2:B6) → 215
Frequently asked questions
Is this the Indeed assessment?
No. FormulaCamp is independent and not affiliated with Indeed. This page practices general spreadsheet skills only.
Will I see the same questions?
There is no way to know. Employers and assessment providers choose and change their own questions, so use your instructions as the source of truth.
What skills should I warm up?
Totals, counts, conditions with IF, exact lookups, and simple cleanup are the common core. Make sure you can explain each result you produce.
Why does the lookup use FALSE?
The last argument asks for an exact match. Without it, VLOOKUP may do an approximate match and return a neighboring row.