Free printablesFree spreadsheet skills practice test
A free printable spreadsheet test for office job interviews: a 12-row sales table and 8 questions on COUNTIF, SUMIF, SUMIFS, AVERAGE and INDEX/MATCH, with answers and formulas.
In the print window choose 100% (or Fit to page) and turn off headers and footers. To keep a PDF, pick “Save as PDF” as the printer.
Spreadsheet skills practice test 8 questions · 15 minutes · type the table into a sheet starting at A1, or work on paper
| A Order ID | B Date | C Region | D Rep | E Product | F Units | G Price ₹ | H Amount ₹ | I Status |
|---|---|---|---|---|---|---|---|---|
| SO-1001 | 02-Jan | South | Rohan M. | Desk Lamp | 31 | 1,250 | 38,750 | Delivered |
| SO-1002 | 04-Jan | East | Vikram J. | USB Keyboard | 26 | 899 | 23,374 | Delivered |
| SO-1003 | 05-Jan | North | Vikram J. | Whiteboard | 9 | 2,400 | 21,600 | Delivered |
| SO-1004 | 05-Jan | North | Priya D. | USB Keyboard | 11 | 899 | 9,889 | Pending |
| SO-1005 | 07-Jan | East | Priya D. | USB Keyboard | 40 | 899 | 35,960 | Pending |
| SO-1006 | 08-Jan | West | Rohan M. | Desk Lamp | 20 | 1,250 | 25,000 | Delivered |
| SO-1007 | 09-Jan | South | Aarav S. | Gel Pen Box | 40 | 150 | 6,000 | Delivered |
| SO-1008 | 09-Jan | North | Kabir T. | Desk Lamp | 35 | 1,250 | 43,750 | Pending |
| SO-1009 | 10-Jan | East | Vikram J. | Office Chair | 8 | 5,800 | 46,400 | Pending |
| SO-1010 | 10-Jan | South | Isha P. | Office Chair | 12 | 5,800 | 69,600 | Delivered |
| SO-1011 | 11-Jan | South | Isha P. | Printer Paper Ream | 16 | 320 | 5,120 | Delivered |
| SO-1012 | 11-Jan | East | Kabir T. | Gel Pen Box | 39 | 150 | 5,850 | Delivered |
- How many orders have the status Delivered?
- What is the total number of units sold?
- What is the total amount for the South region?
- What is the average order amount (2 decimals)?
- Which order has the highest amount? Return its Order ID.
- How many orders have 20 units or more?
- Total amount of Delivered orders in the North region?
- What share of orders was Returned (percent, 1 decimal)?
Answer key (fold this strip under before you start)
1 8 · 2 287 · 3 ₹119,470 · 4 ₹27,607.75 · 5 SO-1010 · 6 7 · 7 ₹21,600 · 8 0.0%
=COUNTIF(I2:I13,"Delivered")=SUM(F2:F13)=SUMIF(C2:C13,"South",H2:H13)=ROUND(AVERAGE(H2:H13),2)=INDEX(A2:A13,MATCH(MAX(H2:H13),H2:H13,0))=COUNTIF(F2:F13,">=20")=SUMIFS(H2:H13,C2:C13,"North",I2:I13,"Delivered")=COUNTIF(I2:I13,"Returned")/COUNTA(A2:A13)
Fictional data, invented for practice. Price and Amount are in Indian rupees (₹). Formulas work in desktop spreadsheet apps and Google Sheets.
Free tool: practice spreadsheet shortcuts online → tools.dojito.com/p/sheet-test/Free sample from Spreadsheet Skills Test Prep · tools.dojito.com/printables/spreadsheet-practice-test/ · Free for personal and classroom use, not for resale · Dojito
About this worksheet
Many data entry, MIS and analyst jobs start with a short practical spreadsheet test. The questions are rarely hard, but the clock is running and the functions have to come out of your fingers without searching. This free page is a 15-minute warm-up in that style.
You get a small sales table with twelve orders — order ID, date, region, sales rep, product, units, price, amount and status — and eight questions about it. They cover the functions that appear in almost every test: COUNTIF, SUM, SUMIF, AVERAGE with ROUND, MAX with INDEX and MATCH, COUNTIF with a comparison, SUMIFS with two conditions, and a simple percentage.
Type the table into a blank sheet starting at cell A1 so the column letters match, then answer each question with one formula. If you are practicing on paper, work the answers out by hand: it is slower, but it forces you to understand what each function adds up or counts. The answer key with the exact formulas is at the bottom of the page — fold it under before you start.
Time yourself. In a real test, eight questions like these should take under ten minutes. If one takes longer, that is the function to drill before the interview.
Full version
The full pack has 50 questions in five job sets (data entry, MIS executive, analyst, accounts & HR admin, mixed mock test) on 120 sales orders and 40 staff records, a solutions workbook with live formulas and plain-English explanations, a printable question booklet and a job search tracker.
Tick the box to turn on the button
Free tools that go with it
More free printables
- EN
Free printable monthly budget worksheet
Income, 12 categories, budget vs actual and an expense log on one page.
- KO
2027 연차 계획표 무료 인쇄
Korean annual-leave planner 2027: leave days by years of service, 24 public holidays, usage log (Korean).
- KO
2027 팀 연차 달력 — 월별 휴가 현황표
Team leave wall calendar for any month of 2027 with Korean holidays shaded (Korean, landscape).
- EN
Free Korean name tracing worksheet
Name tracing page: letters, sound guide, tracing and blank rows for your own name.
- EN
Free Hangul alphabet tracing worksheet
All 24 basic letters with sounds, memory hints and tracing boxes.
- EN
Free printable Korean keyboard layout
Every Hangul key with finger colors, Shift letters, combined vowels and a recall drill.
- EN
Free Korean numbers worksheet
Both number systems 1–10, when to use which, 14 questions on prices, months and time.