Basic Excel Test Questions With Answers (Practice Test)
A free practice Excel test with 15 questions like those in pre-employment assessments: formulas, $ references, IF, COUNTIF, SUMIFS and VLOOKUP, with answers.
By Ayoub Farid · · 2 min read
This practice test mirrors the kind of tasks in basic and intermediate pre-employment Excel assessments. Set a timer for 30 minutes, build the sheet, and answer without looking at the answers.
The data
Type this into A1:E9 (or copy it from your own sales data):
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Region | Product | Qty | Price |
| 2 | 1001 | North | Laptop | 2 | 900 |
| 3 | 1002 | South | Mouse | 10 | 25 |
| 4 | 1003 | North | Monitor | 3 | 200 |
| 5 | 1004 | East | Laptop | 1 | 900 |
| 6 | 1005 | South | Monitor | 2 | 200 |
| 7 | 1006 | North | Mouse | 5 | 25 |
| 8 | 1007 | East | Monitor | 4 | 200 |
| 9 | 1008 | South | Laptop | 1 | 900 |
Questions
- In F2, calculate the order value (Qty × Price) and fill down to F9.
- Total value of all orders.
- Average order value.
- Largest single order value.
- How many orders are there?
- In G2, show each order's share of the total value (must work when filled down).
- In H2, show "Large" if the order value is 1,000 or more, else "Standard".
- How many orders came from the North region?
- Total value of orders from the South region.
- Total quantity of Monitors sold in the North region.
- How many orders have a quantity of 3 or more?
- A price list for Laptop, Mouse, Monitor is in J2:K4. Look up the price of the product in C2 with VLOOKUP so it works when filled down.
- Average price of Monitor orders.
- A 10% discount rate is in M1. In I2, show the discounted price, filled down.
- Total value of North orders worth at least 500.
Answers
=D2*E2→ 1001: 1,800=SUM(F2:F9)→ 5,775=AVERAGE(F2:F9)→ 721.88 (rounded)=MAX(F2:F9)→ 1,800=COUNT(A2:A9)or=COUNTA(A2:A9)→ 8=F2/$F$10(if the total is in F10) or=F2/SUM($F$2:$F$9)=IF(F2>=1000,"Large","Standard")=COUNTIF(B2:B9,"North")→ 3=SUMIF(B2:B9,"South",F2:F9)→ 250 + 400 + 900 = 1,550=SUMIFS(D2:D9,B2:B9,"North",C2:C9,"Monitor")→ 3=COUNTIF(D2:D9,">=3")→ 4=VLOOKUP(C2,$J$2:$K$4,2,FALSE)=AVERAGEIF(C2:C9,"Monitor",E2:E9)→ 200=E2*(1-$M$1)=SUMIFS(F2:F9,B2:B9,"North",F2:F9,">=500")→ 1,800 + 600 = 2,400
How did you do?
- 13–15 correct: you're ready for most basic tests. Move to advanced Excel skills.
- 9–12: review the ones you missed; $ and SUMIFS are the usual culprits.
- Under 9: work through the 10-minutes-a-day plan.
Questions 1–6 and 14 are exactly what Cellio's live units drill: formulas on real sheets, fill down, and $ locks, with feedback when you miss.
Frequently asked questions
What questions are on a basic Excel test?
Totals, averages, percentages, $ references, IF, COUNTIF/SUMIF and a simple lookup are the most common.
How do I pass an Excel assessment?
Practise the core formulas until you can write them without help, and check every filled-down formula.
How long is a basic Excel test?
Often 20 to 45 minutes.
Is this test the same in Google Sheets?
Yes, every formula works in Google Sheets.