Sheetsdrill

All 50 Google Sheets formula exercises

Sheetsdrill is Google Sheets formula practice in your browser. Every exercise gives you a small sheet, a real question and a formula bar. You type the formula, it is checked on the data you see and on a second version you do not, so only a formula that really works passes. The exercises are listed here level by level. 5 are free without an account; Pro unlocks the rest.

Start practicing free

Level 1: Basics

SUM, AVERAGE, ROUND, percentages, absolute references, IF, COUNT and COUNTA.

  1. Total ad spendFree
  2. Average order valueFree
  3. Round the unit priceFree
  4. One rate for every rowFree
  5. Over budget?Free
  6. Share of total salesPro
  7. Month-over-month growthPro
  8. Price after discountPro
  9. Commission over a thresholdPro
  10. Count the survey responsesPro

Level 2: Conditional counting and summing

COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS, date ranges, wildcards, IFS and SWITCH.

  1. Open high-priority ticketsPro
  2. Sales for one rep and monthPro
  3. Won deals above a minimumPro
  4. Average reply timePro
  5. Largest order in a regionPro
  6. Cheapest item in stockPro
  7. Orders between two datesPro
  8. Customer tiers with IFSPro
  9. Region names with SWITCHPro
  10. Contacts on one email domainPro

Level 3: Lookups

VLOOKUP exact and approximate, XLOOKUP with missing values and search modes, INDEX with MATCH, IFNA.

  1. Find the pricePro
  2. Stock on handPro
  3. Look left with XLOOKUPPro
  4. A friendly "Not found"Pro
  5. INDEX and MATCHPro
  6. Zero instead of #N/APro
  7. Shipping rate by weight bandPro
  8. Row and column lookupPro
  9. Latest status in a logPro
  10. Commission rate tierPro

Level 4: Arrays and FILTER

FILTER, UNIQUE, SORT, SORTN, ARRAYFORMULA and QUERY with where, group by and order by.

  1. Sum a filtered listPro
  2. Two conditions in FILTERPro
  3. Distinct customersPro
  4. Best seller with SORTPro
  5. Top three deals with SORTNPro
  6. Revenue with ARRAYFORMULAPro
  7. Codes that are too longPro
  8. QUERY for a totalPro
  9. Top region with QUERYPro
  10. Count with QUERYPro

Level 5: Text and dates

SPLIT, JOIN, TEXTJOIN, REGEXMATCH, REGEXEXTRACT, REGEXREPLACE, TEXT, DATEDIF, NETWORKDAYS, EOMONTH.

  1. First name with SPLITPro
  2. Join the confirmed namesPro
  3. Address without gapsPro
  4. Valid order IDsPro
  5. Pull out the invoice numberPro
  6. Digits onlyPro
  7. Month label with TEXTPro
  8. Full years of servicePro
  9. Working days with holidaysPro
  10. Due at the end of next monthPro

Try the first five exercises free.

No sign-up needed for the first five. If it works for you, Pro unlocks all 50, and a free account saves your progress across devices.

Start practicing free