Top 30 Google Sheets Multiple Choice Questions (MCQs) with Answers

1 .

Google sheet saves the changes automatically?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : Yes, Google sheet saves the changes automatically.

2 .

A group of cells is called as ________ in Google Sheets.

A)

chart

B)

multi cell

C)

cell range

D)

cell cluster

Correct Answer : cell range

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

3 .

A single Google sheet is called ____.

A)

Document

B)

Worksheet

C)

Workbook

D)

Google Shareware

Correct Answer : Worksheet

Explanation : A single Google sheet is called Worksheet.

4 .

Any formula starts with the ______ sign.

A)

Equal (=)

B)

Dollar ($)

C)

Column (:)

D)

Underscore (_)

Correct Answer : Equal (=)

Explanation : In Google sheets, the formulas always start with the equal sign (=).

5 .

In Google sheet, columns are represented by ______.

A)

Cells

B)

Letters

C)

Numbers

D)

Letters and Numbers

Correct Answer : Letters

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 .

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

A)

Ctrl + h

B)

Alt + k

C)

Ctrl + Alt + k

D)

Ctrl + k

Correct Answer : Ctrl + k

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

7 .

Shortcut command to hide rows in Google sheet?

A)

Ctrl + Alt + R

B)

Ctrl + Alt + 0

C)

Ctrl + Alt + 9

D)

Ctrl + Alt + H

Correct Answer : Ctrl + Alt + 9

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

8 .

Shortcut command to show all formulas in Google sheet?

A)

Ctrl + ~

B)

Ctrl + &

C)

Ctrl + F

D)

Ctrl + Shift + F

Correct Answer : Ctrl + ~

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

9 .

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

A)

Equal (=)

B)

Underscore (_)

C)

Column (:)

D)

Dollar ($)

Correct Answer : Dollar ($)

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

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

10 .

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

A)

$B11

B)

=B11

C)

$(B)11

D)

$B$11

Correct Answer : $B$11

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

11 .

Shortcut for ungrouping rows or columns in Google sheet?

A)

Alt + Shift + Up Arrow

B)

Alt + Shift + Left Arrow

C)

Alt + Shift + Right Arrow

D)

Alt + Shift + Down Arrow

Correct Answer : Alt + Shift + Left Arrow

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

12 .

Shortcut for group rows or columns in Google sheet?

A)

Alt + Shift + Right Arrow

B)

Alt + Shift + Left Arrow

C)

Alt + Shift + Up Arrow

D)

Alt + Shift + Down Arrow

Correct Answer : Alt + Shift + Right Arrow

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

13 .

Shortcut to select the current row in Google sheet?

A)

ALT + Space

B)

CTRL + Space

C)

SHIFT + Space

D)

CTRL + SHIFT + Space

Correct Answer : SHIFT + Space

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

14 .

Shortcut to select current column in Google sheet?

A)

ALT + Space

B)

SHIFT + Space

C)

CTRL + Space

D)

CTRL + SHIFT + Space

Correct Answer : CTRL + Space

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

15 .

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

A)

32000

B)

50000

C)

65500

D)

85000

Correct Answer : 50000

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

16 .

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

A)

Functions

B)

Arguments

C)

Formulas

D)

Subfunctions

Correct Answer : Arguments

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

17 .

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

A)

Filters

B)

Statics

C)

Sorting

D)

Reporting

Correct Answer : Filters

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

18 .

Correct steps to group rows or columns in Google sheets.

A)

Data > Group rows or Group columns

B)

Insert > Group rows or Group columns

C)

Format > Group rows or Group columns

D)

None of the above

Correct Answer : Data > Group rows or Group columns

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

19 .

Can we freeze header rows and columns in Google sheets?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

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

20 .

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

A)

DATE()

B)

TODAY()

C)

NOW()

D)

GETDATE()

Correct Answer : NOW()

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

21 .

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

A)

*

B)

^

C)

/

D)

@

Correct Answer : @

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

22 .

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

A)

Clear

B)

Clear all

C)

Clear Styles

D)

Clear Formatting

Correct Answer : 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"

23 .

In Google sheets, the default number format is ___.

A)

Time

B)

Automatic

C)

Number

D)

Currency

Correct Answer : Automatic

Explanation : The default Number format is Automatic.

24 .

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

A)

Currency

B)

Time

C)

Number

D)

Automatic

Correct Answer : Currency

Explaination : 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".

25 .

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

A)

ADD

B)

SUM

C)

SUMIF

D)

SUMRANGE

Correct Answer : SUM

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

Example : = SUM (B2:B10)

26 .

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

A)

SUMIF

B)

ADD

C)

SUM

D)

SUMRANGE

Correct Answer : SUMIF

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])

27 .

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

A)

ADD

B)

SUM

C)

SUMIF

D)

SUMIFS

Correct Answer : 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, ...])

28 .

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

A)

OR()

B)

AND()

C)

Both (A) and (B)

D)

NOT()

Correct Answer : Both (A) and (B)

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

29 .

____ function returns the current date as a date value.

A)

DATE()

B)

NOW()

C)

TODAY()

D)

GETDATE()

Correct Answer : TODAY()

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

30 .

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

A)

MULT()

B)

SNGL()

C)

Both (A) and (B)

D)

None of the above

Correct Answer : 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, ...])

31 .

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

A)

Sort

B)

Data Sort

C)

Sort Data

D)

Sort Range

Correct Answer : Sort Range

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"

32 .

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

A)

AM

B)

AVERAGE

C)

AVERAGEIF

D)

AVERAGEIFS

Correct Answer : AVERAGE

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

Syntax :

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

33 .

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

A)

AM

B)

AVERAGE

C)

AVERAGEIF

D)

AVERAGEIFS

Correct Answer : AVERAGEIF

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])

34 .

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

A)

AVERAGEIFS

B)

AVERAGE

C)

AVERAGEIF

D)

None of the above

Correct Answer : AVERAGEIFS

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, ...)