Sheetsdrill

Free Google Sheets practice test for interviews

Ten hands-on formula questions on live sheets, one 15-minute clock, and a score broken down by skill area. No sign-up to start.

Questions
10
Minutes
15
Skill areas
5
Price
Free
Test resultExample result

Working knowledge

Correct
7 of 10
Time
11:42 of 15:00
Skill areaScoreShare correct
Basics2/2
Strong
Conditional counting and summing2/2
Strong
Lookups1/2
Review
Arrays and FILTER1/2
Review
Text and dates1/2
Review
An example of the result you get: a score, your time, and each skill area marked.

What the test covers

Google Sheets tests for operations, marketing, sales ops and analyst roles draw on the same short list of skills. The test takes two questions from each of the five, picked at random each time.

  • Basics

    Totals, averages, rounding, percentages, a simple IF, and locking a cell with dollar signs so a formula can be copied down. SUM, AVERAGE, ROUND, IF, $A$1

    2 of 1015 exercises
  • Conditional counting and summing

    Counts, totals and averages that depend on one or more conditions, including date ranges and wildcards. COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, IFS

    2 of 1020 exercises
  • Lookups

    Pulling a value from a table by its key, exact and approximate match, a lookup to the left, and a clean result when the key is missing. VLOOKUP, XLOOKUP, INDEX, MATCH, IFNA

    2 of 1016 exercises
  • Arrays and FILTER

    The functions Google Sheets is known for: filtered and distinct lists, sorting, whole-column formulas and QUERY. FILTER, UNIQUE, SORT, ARRAYFORMULA, QUERY

    2 of 1019 exercises
  • Text and dates

    Splitting and joining text, pulling a pattern out of a cell with a regular expression, and date math such as working days. SPLIT, TEXTJOIN, REGEXEXTRACT, DATEDIF, NETWORKDAYS

    2 of 1022 exercises
No sign-up. No card.

Three sample questions

These come from the same pool as the test. In the test you type the formula into the highlighted cell and it is checked on the data you see, then again on changed data.

Q1Sales for one rep and month

Conditional counting and summing

Add up the amounts for the rep named in F1 in the month in F2. Point at F1 and F2 instead of typing the values. Answer in F3.

ABCDEF
1RepMonthAmountRepAva
2AvaJan$1,200.00MonthJan
3BenJan$950.00Total
4AvaFeb$1,430.00
5CaraJan$700.00
6BenFeb$1,100.00
7AvaJan$380.00
8CaraFeb$1,650.00
9BenJan$520.00
10AvaFeb$610.00
11CaraJan$900.00
Show the answer

F3=SUMIFS(C2:C11,A2:A11,F1,B2:B11,F2)

In SUMIFS the sum range comes first. That order lets you add as many condition pairs as you need.

Open this exercise

Q2Look left with XLOOKUP

Lookups

Return the email address of the person named in F1. The names are in column C and the emails are to their left, so use XLOOKUP. Answer in F2.

ABCDEF
1EmailTeamNameNameDan Kim
2a.chen@example.comDesignAmy ChenEmail
3b.osei@example.comSalesBen Osei
4c.ruiz@example.comSupportCarla Ruiz
5d.kim@example.comSalesDan Kim
6e.novak@example.comFinanceEva Novak
7f.ali@example.comDesignFarid Ali
8g.moss@example.comSupportGina Moss
Show the answer

F2=XLOOKUP(F1,C2:C8,A2:A8)

XLOOKUP matches exactly by default and does not care which side the result column is on.

Open this exercise

Q3Top region with QUERY

Arrays and FILTER

Use QUERY to total revenue by region, sort the totals from largest to smallest and keep one row. Return just the region name in F1 (INDEX helps).

ABCDEF
1RegionRepRevenueTop region
2SouthKai$2,300.00
3NorthLia$1,800.00
4WestMax$2,650.00
5SouthNoa$1,900.00
6NorthOli$2,750.00
7WestPia$1,200.00
8SouthQuin$900.00
9NorthRay$1,350.00
10WestSol$2,100.00
11SouthTia$1,450.00
Show the answer

F1=INDEX(QUERY(A1:C11,"select A, sum(C) group by A order by sum(C) desc limit 1",1),2,1)

group by collapses rows, order by ranks the groups and limit keeps the top. That is a full report in one formula.

Open this exercise

How scoring works

  • Each question is worth one point. You get the point when your formula returns the right result on the sheet shown and on a second version with different inputs, so an answer typed in as a number does not score.
  • You can check a formula as often as you like while the clock runs. A question you skip, or have not solved when the 15 minutes end, counts as wrong.
  • The result shows your score out of 10, the time you took, and each skill area as strong or to review, with links to the exercises for the areas you missed.

What your score means

  • 0 to 4Foundations first

    Start with Basics and Conditional counting and summing, then come back. The later levels build on them.

  • 5 to 7Working knowledge

    The core is there. The areas you missed are the ones to drill before a timed assessment.

  • 8 to 10Interview-ready on this set

    You solved questions from nearly every level under the clock. Drill the one or two areas you missed and you are in good shape.

These bands describe this test only. Employers set their own pass marks, and we do not know them.

Take the test

10 questions from 5 skill areas, 15 minutes on the clock. It starts right here, with no account and no email.

  • Hints and solutions are off while the clock runs.
  • Check a formula as often as you like. Skip counts as wrong.
  • Your answers survive a page reload.

The mistakes that cost the most points

The same five mistakes repeat across the exercises on Sheetsdrill. Fix them before a timed test.

  • Forgetting to lock a reference. A rate referenced as F1 instead of $F$1 is right in the first row and wrong when the formula is filled down.
  • Using VLOOKUP when the answer is to the left of the lookup column. VLOOKUP cannot look left; XLOOKUP or INDEX with MATCH can.
  • Approximate match by accident. Leave out VLOOKUP's last argument and it assumes sorted data, which returns a wrong but plausible value when the exact key is missing.
  • Criteria typed into the formula. SUMIFS(C2:C11, A2:A11, "Ava") works until someone asks about another rep; pointing at a cell makes one formula serve every name.
  • Text that looks like a number. SPLIT pieces and REGEXEXTRACT results are text, so a sum over them returns zero until you wrap the result in VALUE.

The three formats a Google Sheets test comes in

  • Multiple choice about Sheets knowledge: which function returns distinct values, what #N/A means.
  • Live tasks in a sheet, usually timed: fill the marked cells, build the summary, fix the formula. This test is that format, because knowing a function and writing it under a clock are different skills.
  • A take-home case: a messy export and a list of questions. Accuracy matters more than speed, and cleaning the data is tested as much as the formulas.

Questions

Is the Google Sheets practice test really free?

Yes. The test is free and you do not need a card. Free visitors get one attempt a day; Pro members can retake it any time.

Do I need an account or a Google login?

No to both. The test starts in one click and runs on a sheet in your browser that follows Google Sheets rules for the functions covered. The formulas you write work unchanged in Google Sheets.

How long does the test take?

Up to 15 minutes. There are 10 questions on one clock, and the test ends when you finish the last question or the time runs out.

How is the test scored?

One point per question, 10 in total. A formula scores when it returns the right result on the data shown and again on changed data. Skipped or unsolved questions count as wrong. You also get a breakdown by skill area.

Is it like the Google Sheets test employers use?

It uses the hands-on format: you write real formulas on a sheet under a clock, which is how live spreadsheet assessments work. It is not a copy of any employer's or testing company's test, and it does not include multiple-choice questions, pivot tables or charts.

Can I retake the test?

Yes. The questions are drawn at random from the exercise pool, so a retake is a different test. Free visitors can retake it the next day; Pro removes the limit.

What comes after the test?

Your result links straight to the exercises for the areas you missed. Your first 15 exercises on Sheetsdrill are free without an account, and questions you solve in the test count toward them. Pro unlocks all 92 exercises, every reference solution, timed mode and the certificate.

Find out where you stand

Ten questions, 15 minutes, a score by skill area. Free, and no sign-up to start.