We designed these Google Sheets MCQs to help every professional and student. Google Sheets multiple-choice questions have been designed by the experts and we tried to cover all the topics. Practice these MCQs to test and enhance your knowledge in Google Sheets.

## List of Google Sheets MCQs

1. A single Google sheet is called ____.

1. Workbook
2. Document
4. Worksheet

Explanation:

A single Google sheet is called Worksheet.

2. Google sheet saves the changes automatically?

1. Yes
2. No

Explanation:

Yes, Google sheet saves the changes automatically.

3. A group of cells is known as ___ in Google Sheets.

1. Cells group
2. Multi cells
3. Collection
4. Cell range

Explanation:

In Google sheets, the group of cells is called cell range.

4. Any formula starts with the ___ sign.

1. Underscore (_)
2. Dollar (\$)
3. Equal (=)
4. Column (:)

Explanation:

5. In Google sheet, columns are represented by ____.

1. Numbers
2. Letters
3. Letters and Numbers
4. Cells

Explanation:

In Google sheets, columns are represented by letters. For example, the first column is A, the second column is B, and so on ...

6. Which sign is used in the formula to use absolute reference?

1. Underscore (_)
2. Dollar (\$)
3. Equal (=)
4. Column (:)

Explanation:

The dollar sign (\$) is used in the formula to use absolute reference.

Example: Absolute reference for row and column: \$A\$1

7. If the tax (any value) reference is B11, and you do not want the fill function to change this, so we lock it using ____.

1. \$B\$11
2. \$B11
3. \$(B)11
4. =B11

Explanation:

The reference is absolutely locked by using the formula \$B\$11.

8. Which of the following is an absolute cell reference?

1. B2
2. #B2
3. B:2
4. \$B\$2

Explanation:

\$B\$2 is an absolute cell reference.

9. In a single cell, the maximum limit of the characters is ____.

1. 65536
2. 18730
3. 50000
4. 32364

Explanation:

The maximum number of characters is 50,000 in a single cell.

10. In Google sheets, most of the functions contain one or more ____ in parentheses.

1. Arguments
2. Formulas
3. Functions
4. Subfunctions

Explanation:

In Google sheets, most of the functions contain one or more arguments in parentheses.

11. Which feature allows you to narrow down the data in your worksheet?

1. Filters
2. Reporting
3. Sorting
4. Statics

Explanation:

The Filters allow you to narrow down the data in your worksheet.

12. Which symbol is not recognized as mathematical operators within Google Sheets?

1. ^
2. /
3. *
4. @

Explanation:

The @ symbol is not a mathematical operator, the rest of all are the mathematical operators in Google sheets.

13. Which command is used to clear the formatting of selected cells in Google sheets?

1. Clear
2. Clear all
3. Clear Styles
4. Clear Formatting

Explanation:

The clear formatting command is used to clear the formatting of selected cells.

Steps to clear formatting of selected cells in Google sheets:

• Select the cells
• Click on the "Format menu"
• And then, select "Clear formatting"

14. In Google sheets, the default number format is ___.

1. Automatic
2. Number
3. Currency
4. Time

Explanation:

The default Number format is Automatic.

15. Which format represents the numbers with the dollars (\$) sign? [For example, \$1,000.00]

1. Automatic
2. Number
3. Currency
4. Time

Explanation:

The currency represents the numbers with the dollars (\$) sign. For this, select the cells containing the numbers and click on the "Format Menu", and then the "Number" option and click on "Currency".

16. Which function adds up numbers in a range in Google sheets?

2. SUM
3. SUMIF
4. SUMRANGE

Explanation:

To add up numbers in a range - SUM() function is used.

Example: = SUM (B2:B10)

17. Which function calculates the sum of values in a range based on a true or false condition?

2. SUM
3. SUMIF
4. SUMRANGE

Explanation:

To calculate the sum of values in a range based on a true or false condition - SUMIF() function is used.

Syntax:

`=SUMIF(range, criterion, [sum_range])`

18. Which function calculates the sum of a range based on one or more true or false conditions?

2. SUM
3. SUMIF
4. SUMIFS

Explanation:

To calculate the sum of a range based on one or more true or false conditions - SUMIFS() function is used.

Syntax:

`=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...])`

19. Which function(s) is/are used to check combinations of two or more conditions in Google sheets?

1. AND()
2. OR()
3. Both A and B
4. NOT()

Answer: C) Both A and B

Explanation:

Both AND() and OR() functions are used to check combinations of two or more conditions in Google sheets.

20. Which function is used to find the average (arithmetic mean)?

1. AVERAGE
2. AVERAGEIF
3. AVERAGEIFS
4. AM

Explanation:

The AVERAGE() function is used to calculate the average (arithmetic mean).

Syntax:

`=AVERAGE(value1, [value2, ...])`

21. Which function is used to find the average (arithmetic mean) of a range based on a true or false condition?

1. AVERAGE
2. AVERAGEIF
3. AVERAGEIFS
4. AM

Explanation:

The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on a true or false condition.

Syntax:

`=AVERAGEIF(criteria_range, criterion, [average_range])`

22. Which function is used to find the average (arithmetic mean) of a range based on one or more true or false conditions?

1. AVERAGE
2. AVERAGEIF
3. AVERAGEIFS
4. AM

Explanation:

The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on one or more true or false conditions.

Syntax:

`=AVERAGEIFS(average_range, criteria_range1, criterion1, ...)`

23. The ____ command in Google Sheets allows for more complex sorting of data.

1. Sort
2. Sort Range
3. Sort Data
4. Data Sort

Explanation:

The Sort Range command in Google Sheets allows for more complex sorting of data.

Steps to use the Sort Range command:

• Select a range
• Click on the "Data" menu and find "Sort Range"
• Click on "Sort Range"
• Select Data has header row
• Select Total stats which is the header for the column
• Click "Sort"

24. Which function is used to find the most common value(s)?

1. SNGL()
2. MULT()
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

Both MODE.SNGL() and MODE.MULT() functions are used to find the most common value(s).

```=MODE.SNGL(value1, [value2, ...])
=MODE.MULT(value1, [value2, ...])```

25. ____ function returns the current date as a date value.

1. DATE()
2. TODAY()
3. NOW()
4. GETDATE()

Explanation:

TODAY() function returns the current date as a date value.

26. ____ function returns the current date and time as a date value.

1. DATE()
2. TODAY()
3. NOW()
4. GETDATE()

Explanation:

NOW() function returns the current date and time as a date value.

27. Correct steps to group rows or columns in Google sheets.

1. Data > Group rows or Group columns
2. Format > Group rows or Group columns
3. Insert > Group rows or Group columns
4. None of the above

Answer: A) Data > Group rows or Group columns

Explanation:

The correct steps to group rows or group columns: 1) Select the rows/columns, 2) Click Data > Group rows or Group columns.

1. Yes
2. No

Explanation:

Yes, we can freeze header rows and columns. On the menu bar, click "View" and then "Freeze" and choose an option.

29. Shortcut to select current column in Google sheet?

1. CTRL + Space
2. ALT + Space
3. SHIFT + Space
4. CTRL + SHIFT + Space

Explanation:

Press CTRL + Space to select the current column in Google Sheets.

30. Shortcut to select the current row in Google sheet?

1. CTRL + Space
2. ALT + Space
3. SHIFT + Space
4. CTRL + SHIFT + Space

Explanation:

Press SHIFT + Space to select the current row in the Google sheet.

31. Shortcut for group rows or columns in Google sheet?

1. Alt + Shift + Right Arrow
2. Alt + Shift + Left Arrow
3. Alt + Shift + Down Arrow
4. Alt + Shift + Up Arrow

Answer: A) Alt + Shift + Right Arrow

Explanation:

Press Alt + Shift + Right Arrow to open the group rows or columns option in Google sheet.

32. Shortcut for ungrouping rows or columns in Google sheet?

1. Alt + Shift + Right Arrow
2. Alt + Shift + Left Arrow
3. Alt + Shift + Down Arrow
4. Alt + Shift + Up Arrow

Answer: B) Alt + Shift + Left Arrow

Explanation:

Press Alt + Shift + Left Arrow to ungroup selected rows or columns in the Google sheet.

33. Shortcut command to show all formulas in Google sheet?

1. Ctrl + F
2. Ctrl + Shift + F
3. Ctrl + &
4. Ctrl + ~

Explanation:

Press Ctrl + ~ to show all formulas in Google sheet, press the same command again to show the values.

34. Shortcut command to hide rows in Google sheet?

1. Ctrl + Alt + R
2. Ctrl + Alt + H
3. Ctrl + Alt + 9
4. Ctrl + Alt + 0

Answer: C) Ctrl + Alt + 9

Explanation:

Press Ctrl + Alt + 9 to hide rows in Google Sheets.

35. Shortcut command to insert a link on selected text/cell?

1. Ctrl + k
2. Ctrl + h
3. Ctrl + Alt + k
4. None of the above

Explanation:

Press Ctrl + k to insert a link on selected text/cell in Google sheet.

What's New (MCQs)

Top Interview Coding Problems/Challenges!

IncludeHelp's Blogs

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates