Home > Google > Quizzes > Basic Google Sheets Practice Test
Basic Google Sheets Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 84% Most missed: “In Google sheets, the default number format is ___.”
Google Sheets is a spreadsheet application included as part of the free, web-based Google Docs Editors suite offered by Google. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. The major difference between Microsoft Excel and Google Sheets is that you can share the link of Google Sheets with anyone and they can edit the file. Google Sheets can be integrated with other Google products such as Google Form, Google Finance, Google Translate, and Google Drawings. Some advantages of using Google Sheets include: Integration... Show more
Basic Google Sheets Practice Test
Time left 00:00
25 Questions

1. If the tax (any value) reference is B11, and you do not want the fill function to change this, so we lock it using ____.
2. Shortcut for ungrouping rows or columns in Google sheet?
3. Any formula starts with the ___ sign.
4. Which function is used to find the most common value(s)?
5. Correct steps to group rows or columns in Google sheets.
6. Which function is used to find the average (arithmetic mean) of a range based on one or more true or false conditions?
7. Shortcut command to show all formulas in Google sheet?
8. Google sheet saves the changes automatically?
9. Shortcut to select current column in Google sheet?
10. Shortcut command to insert a link on selected text/cell?
11. Which feature allows you to narrow down the data in your worksheet?
12. A single Google sheet is called ____.
13. The ____ command in Google Sheets allows for more complex sorting of data.
14. Shortcut to select the current row in Google sheet?
15. Which function calculates the sum of values in a range based on a true or false condition?
16. Which format represents the numbers with the dollars ($) sign? [For example, $1,000.00]
17. Shortcut command to hide rows in Google sheet?
18. Which symbol is not recognized as mathematical operators within Google Sheets?
19. Which of the following is an absolute cell reference?
20. In a single cell, the maximum limit of the characters is ____.
21. Which function adds up numbers in a range in Google sheets?
22. Can we freeze header rows and columns in Google sheets?
23. Which function is used to find the average (arithmetic mean) of a range based on a true or false condition?
24. Which function is used to find the average (arithmetic mean)?
25. Which command is used to clear the formatting of selected cells in Google sheets?