---
title: "Google Sheets practice exercises | PracticeExcel"
description: "Free Google Sheets practice exercises in a live grid: QUERY, ARRAYFORMULA, SPLIT, SUMIF, VLOOKUP and more, checked as you type."
canonical_url: "https://practiceexcelonline.com/sheets"
locale: en
meta:
"og:description": "Free Google Sheets practice exercises in a live grid: QUERY, ARRAYFORMULA, SPLIT, SUMIF, VLOOKUP and more, checked as you type."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Google%2BSheets%2Bpractice%2Bexercises%2Cdescription_~RnJlZSBHb29nbGUgU2hlZXRzIHByYWN0aWNlIGV4ZXJjaXNlcyBpbiBhIGxpdmUgZ3JpZDogUVVFUlksIEFSUkFZRk9STVVMQSwgU1BMSVQsIFNVTUlGLCBWTE9PS1VQIGFuZCBtb3JlLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Csite_practiceexcel%2Cp_Ii9zaGVldHMi%2Cs_dEopkh2lzD6mCSV_.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Google Sheets practice exercises | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Google%2BSheets%2Bpractice%2Bexercises%2Cdescription_~RnJlZSBHb29nbGUgU2hlZXRzIHByYWN0aWNlIGV4ZXJjaXNlcyBpbiBhIGxpdmUgZ3JpZDogUVVFUlksIEFSUkFZRk9STVVMQSwgU1BMSVQsIFNVTUlGLCBWTE9PS1VQIGFuZCBtb3JlLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Csite_practiceexcel%2Cp_Ii9zaGVldHMi%2Cs_dEopkh2lzD6mCSV_.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **Google Sheets practice exercises**
Every exercise opens a grid that works like Google Sheets, right in your browser. Type the formula, press Enter and you see at once whether it works. Start with QUERY, the function only Sheets has, or warm up with SUMIF and VLOOKUP.
**Start here**
**Pick columns with select**
QUERY · Lesson 1 of 5
[**Start → **](https://practiceexcelonline.com/sheets/practice/query/query-select-columns)
**Your progress**
**0** of 52 lessons done
**Only in Google Sheets**LogicConditional sums and countsLookups
Your progress is saved in this browser. Create a free account to keep it on every device and start a streak.
[**Create free account**](https://practiceexcelonline.com/signup)
## **Topics**
### **Only in Google Sheets**
0/14
- [**QUERY**](https://practiceexcelonline.com/sheets/practice/query)**Premium**[Pick columns with select](https://practiceexcelonline.com/sheets/practice/query/query-select-columns) [Keep rows with where](https://practiceexcelonline.com/sheets/practice/query/query-where-number) [Match text in where](https://practiceexcelonline.com/sheets/practice/query/query-where-text) [Totals per group with group by](https://practiceexcelonline.com/sheets/practice/query/query-group-by-sum) [Top results with order by and limit](https://practiceexcelonline.com/sheets/practice/query/query-order-by-limit)
- [**ARRAYFORMULA**](https://practiceexcelonline.com/sheets/practice/arrayformula)**Premium**[One formula for a whole column](https://practiceexcelonline.com/sheets/practice/arrayformula/arrayformula-multiply-columns) [IF for every row](https://practiceexcelonline.com/sheets/practice/arrayformula/arrayformula-if) [Join two columns for every row](https://practiceexcelonline.com/sheets/practice/arrayformula/arrayformula-join-columns)
- [**SPLIT and JOIN**](https://practiceexcelonline.com/sheets/practice/split-join)**Premium**[Split a name with SPLIT](https://practiceexcelonline.com/sheets/practice/split-join/split-name) [Split a date into numbers](https://practiceexcelonline.com/sheets/practice/split-join/split-date) [Join a list with JOIN](https://practiceexcelonline.com/sheets/practice/split-join/join-list)
- [**REGEX functions**](https://practiceexcelonline.com/sheets/practice/regex)**Premium**[Test text with REGEXMATCH](https://practiceexcelonline.com/sheets/practice/regex/regexmatch) [Pull out a number with REGEXEXTRACT](https://practiceexcelonline.com/sheets/practice/regex/regexextract-number) [Keep only digits with REGEXREPLACE](https://practiceexcelonline.com/sheets/practice/regex/regexreplace-digits)
### **Logic**
0/5
- [**IF**](https://practiceexcelonline.com/sheets/practice/if)**Premium**[Pass or fail with IF](https://practiceexcelonline.com/sheets/practice/if/if-pass-fail) [Calculate a bonus with IF](https://practiceexcelonline.com/sheets/practice/if/if-calculate-bonus) [Three outcomes with nested IF](https://practiceexcelonline.com/sheets/practice/if/nested-if) [Flag missing values with ISBLANK](https://practiceexcelonline.com/sheets/practice/if/if-isblank-missing) [Compare two cells with IF](https://practiceexcelonline.com/sheets/practice/if/if-compare-two-cells)
### **Conditional sums and counts**
0/18
- [**COUNTIF**](https://practiceexcelonline.com/sheets/practice/countif)**Premium**[COUNTIF with a text condition](https://practiceexcelonline.com/sheets/practice/countif/countif-text) [COUNTIF with a number condition](https://practiceexcelonline.com/sheets/practice/countif/countif-greater-than) [COUNTIF with the limit in a cell](https://practiceexcelonline.com/sheets/practice/countif/countif-criteria-from-a-cell) [Count everything except one value](https://practiceexcelonline.com/sheets/practice/countif/countif-not-equal) [Count with a wildcard](https://practiceexcelonline.com/sheets/practice/countif/countif-wildcard-contains)
- [**SUMIF**](https://practiceexcelonline.com/sheets/practice/sumif)**Premium**[SUMIF with a text criterion](https://practiceexcelonline.com/sheets/practice/sumif/sumif-text-criteria) [SUMIF with a number condition](https://practiceexcelonline.com/sheets/practice/sumif/sumif-greater-than) [SUMIF with a separate sum\_range](https://practiceexcelonline.com/sheets/practice/sumif/sumif-with-sum-range "SUMIF with a separate sum_range") [SUMIF with the criterion in a cell](https://practiceexcelonline.com/sheets/practice/sumif/sumif-criteria-from-a-cell) [SUMIF with a wildcard](https://practiceexcelonline.com/sheets/practice/sumif/sumif-wildcard-contains)
- [**SUMIFS**](https://practiceexcelonline.com/sheets/practice/sumifs)**Premium**[SUMIFS with two conditions](https://practiceexcelonline.com/sheets/practice/sumifs/sumifs-two-conditions) [SUMIFS with the conditions in cells](https://practiceexcelonline.com/sheets/practice/sumifs/sumifs-criteria-from-cells) [SUMIFS between two dates](https://practiceexcelonline.com/sheets/practice/sumifs/sumifs-between-two-dates) [SUMIFS that leaves one value out](https://practiceexcelonline.com/sheets/practice/sumifs/sumifs-not-equal)
- [**COUNTIFS**](https://practiceexcelonline.com/sheets/practice/countifs)**Premium**[COUNTIFS with two conditions](https://practiceexcelonline.com/sheets/practice/countifs/countifs-two-conditions) [Count between two numbers with COUNTIFS](https://practiceexcelonline.com/sheets/practice/countifs/countifs-between-two-numbers) [Count the orders between two dates](https://practiceexcelonline.com/sheets/practice/countifs/countifs-between-two-dates) [COUNTIFS with the conditions in cells](https://practiceexcelonline.com/sheets/practice/countifs/countifs-criteria-from-cells)
### **Lookups**
0/15
- [**VLOOKUP**](https://practiceexcelonline.com/sheets/practice/vlookup)**Premium**[Look up a price with VLOOKUP](https://practiceexcelonline.com/sheets/practice/vlookup/vlookup-exact-match) [VLOOKUP a number key](https://practiceexcelonline.com/sheets/practice/vlookup/vlookup-number-id) [VLOOKUP with an approximate match](https://practiceexcelonline.com/sheets/practice/vlookup/vlookup-approximate-match) [Bring prices into an order list](https://practiceexcelonline.com/sheets/practice/vlookup/vlookup-fill-down-locked-table)
- [**INDEX and MATCH**](https://practiceexcelonline.com/sheets/practice/index-match)**Premium**[Find a position with MATCH](https://practiceexcelonline.com/sheets/practice/index-match/match-function) [Look up a price with INDEX and MATCH](https://practiceexcelonline.com/sheets/practice/index-match/index-match) [Look to the left with INDEX and MATCH](https://practiceexcelonline.com/sheets/practice/index-match/index-match-left-lookup) [A two-way lookup with INDEX and two MATCHes](https://practiceexcelonline.com/sheets/practice/index-match/index-match-match-two-way)
- [**XLOOKUP**](https://practiceexcelonline.com/sheets/practice/xlookup)**Premium**[Look up a price with XLOOKUP](https://practiceexcelonline.com/sheets/practice/xlookup/xlookup) [XLOOKUP with a not-found value](https://practiceexcelonline.com/sheets/practice/xlookup/xlookup-if-not-found) [Find the latest match with XLOOKUP](https://practiceexcelonline.com/sheets/practice/xlookup/xlookup-last-match) [The smallest box that fits with XLOOKUP](https://practiceexcelonline.com/sheets/practice/xlookup/xlookup-next-larger)
- [**IFERROR**](https://practiceexcelonline.com/sheets/practice/iferror)**Premium**[Hide #N/A with IFERROR](https://practiceexcelonline.com/sheets/practice/iferror/iferror-vlookup) [Avoid #DIV/0! with IFERROR](https://practiceexcelonline.com/sheets/practice/iferror/iferror-div0) [Catch only "not found" with IFNA](https://practiceexcelonline.com/sheets/practice/iferror/ifna-vlookup-not-found)
## **Functions in Google Sheets**
### **Only in Google Sheets**
Functions Excel does not have. Each page has the syntax, worked examples and an exercise.
- [**ARRAYFORMULA**](https://practiceexcelonline.com/sheets/functions/arrayformula)
- [**COUNTUNIQUE**](https://practiceexcelonline.com/sheets/functions/countunique)
- [**JOIN**](https://practiceexcelonline.com/sheets/functions/join)
- [**QUERY**](https://practiceexcelonline.com/sheets/functions/query)
- [**REGEXEXTRACT**](https://practiceexcelonline.com/sheets/functions/regexextract)
- [**REGEXMATCH**](https://practiceexcelonline.com/sheets/functions/regexmatch)
- [**REGEXREPLACE**](https://practiceexcelonline.com/sheets/functions/regexreplace)
- [**SPLIT**](https://practiceexcelonline.com/sheets/functions/split)
### **Same as in Excel**
These work the way they do in Excel. Each page says what to watch for in Sheets.
- [**COUNTIF**](https://practiceexcelonline.com/sheets/functions/countif)
- [**COUNTIFS**](https://practiceexcelonline.com/sheets/functions/countifs)
- [**IF**](https://practiceexcelonline.com/sheets/functions/if)
- [**IFERROR**](https://practiceexcelonline.com/sheets/functions/iferror)
- [**INDEX**](https://practiceexcelonline.com/sheets/functions/index)
- [**MATCH**](https://practiceexcelonline.com/sheets/functions/match)
- [**SUMIF**](https://practiceexcelonline.com/sheets/functions/sumif)
- [**SUMIFS**](https://practiceexcelonline.com/sheets/functions/sumifs)
- [**VLOOKUP**](https://practiceexcelonline.com/sheets/functions/vlookup)
- [**XLOOKUP**](https://practiceexcelonline.com/sheets/functions/xlookup)
## **Why practice Google Sheets here**
Most Google Sheets tutorials are videos or templates you copy into your own Drive. You watch someone else type a formula and never find out whether you could write it yourself. Here every exercise is a small sheet with a task, and the formula you type is checked against the answer, against the shape of the right formula and against fresh data, so a typed-in number or a lucky guess does not pass.
The grid behaves like Google Sheets: the same functions, the same blue selection, F2 to edit, Enter and Tab to move, Ctrl+D to fill down and F4 to switch between relative and absolute references. There is nothing to install, and you do not need a Google account to start.
## **What works the same as in Excel**
SUM, IF, SUMIF, COUNTIF, VLOOKUP, XLOOKUP, INDEX and MATCH take the same arguments in Google Sheets as in Excel and give the same answers. That is why the exercises in those topics are the same as on our Excel pages: practice them once and you can use them in both.
Your progress is shared too. A lesson you finish here counts on the Excel pages and the other way around, so you never solve the same sheet twice to earn the points.
## **What is different in Google Sheets**
Google Sheets has functions Excel does not: QUERY asks a range questions in a language much like SQL, ARRAYFORMULA runs one formula down a whole column, SPLIT and JOIN take text apart and put it back together, and REGEXMATCH, REGEXEXTRACT and REGEXREPLACE find patterns in text. They have their own topics at the top of this page.
A few errors look different. When a result has no room to spill into the cells next to it, Sheets shows #REF! where Excel shows #SPILL!. FILTER with no matches gives #N/A instead of #CALC!, and empty cells in a spilled result stay empty instead of showing 0.
Plain formulas over ranges behave differently too. In Excel 365, =B2:B10\*C2:C10 spills on its own; in Google Sheets you wrap it in ARRAYFORMULA. Our grid accepts both, but the ARRAYFORMULA exercises ask for it, because that is what you will need in a real sheet.
## **Function names and separators**
Google Sheets shows function names in the language of your Google account, unless you tick Always use English function names under File > Settings. These pages use the English names and commas between arguments, as Sheets does in an English or US locale. In a locale that writes decimals with a comma, Sheets puts semicolons between arguments instead.
## **How the exercises work**
Each lesson is one task on a small sheet, with the answer cell marked. Some open with a few steps that explain the idea before you write the formula. If your answer is wrong you get a hint that says what is wrong, not just that it is.
The first lesson of every topic is free, with no account. Create a free account to keep your progress on every device; premium opens every lesson and the timed job tests.
## **Questions**
### Are Google Sheets formulas the same as Excel formulas?
Mostly. Everyday functions such as SUM, IF, SUMIF, VLOOKUP and XLOOKUP take the same arguments and give the same results. Sheets adds functions Excel does not have, such as QUERY, ARRAYFORMULA, SPLIT and the REGEX functions, and shows a few errors differently.
### Do I need a Google account to practice?
No. The exercises run in your browser on our own grid, which works like Google Sheets. You only need an account with us if you want to keep your progress on more than one device.
### What does ARRAYFORMULA do?
It makes a formula work on whole ranges at once, so one formula in the top cell fills the whole column. =ARRAYFORMULA(B2:B10\*C2:C10) multiplies every row and spills the results down.
### Is QUERY hard to learn?
Not if you know a little SQL, and not much harder if you don't. A query is a short sentence such as select A, sum(C) group by A. Start with select and where, then add group by and order by; the QUERY topic goes in that order.
### Are the Google Sheets exercises free?
The first lesson of every topic is free, with no account. Premium opens every lesson on both the Excel and the Google Sheets pages.
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/sheets#webpage","description":"Free Google Sheets practice exercises in a live grid: QUERY, ARRAYFORMULA, SPLIT, SUMIF, VLOOKUP and more, checked as you type.","name":"Google Sheets practice exercises","url":"https://practiceexcelonline.com/sheets","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/sheets#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/sheets#/schema/question/1"},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/2"},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/3"},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/4"},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/sheets"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/sheets#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Google Sheets practice exercises","position":2}]},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Are Google Sheets formulas the same as Excel formulas?","acceptedAnswer":{"@type":"Answer","text":"Mostly. Everyday functions such as SUM, IF, SUMIF, VLOOKUP and XLOOKUP take the same arguments and give the same results. Sheets adds functions Excel does not have, such as QUERY, ARRAYFORMULA, SPLIT and the REGEX functions, and shows a few errors differently."}},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Do I need a Google account to practice?","acceptedAnswer":{"@type":"Answer","text":"No. The exercises run in your browser on our own grid, which works like Google Sheets. You only need an account with us if you want to keep your progress on more than one device."}},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What does ARRAYFORMULA do?","acceptedAnswer":{"@type":"Answer","text":"It makes a formula work on whole ranges at once, so one formula in the top cell fills the whole column. =ARRAYFORMULA(B2:B10*C2:C10) multiplies every row and spills the results down."}},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Is QUERY hard to learn?","acceptedAnswer":{"@type":"Answer","text":"Not if you know a little SQL, and not much harder if you don't. A query is a short sentence such as select A, sum(C) group by A. Start with select and where, then add group by and order by; the QUERY topic goes in that order."}},{"@id":"https://practiceexcelonline.com/sheets#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Are the Google Sheets exercises free?","acceptedAnswer":{"@type":"Answer","text":"The first lesson of every topic is free, with no account. Premium opens every lesson on both the Excel and the Google Sheets pages."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.