> > Google Sheets MCQs > Basic Google Sheets MCQs

Basic Google Sheets MCQ

1. A single spreadsheet document is often called a ____.

Insert

Shareware

Worksheet

Microsoft Paint

Answer

Correct Answer: Worksheet

Note: This Question is unanswered, help us to find answer for this one

2. Who is allowed to set editing permissions for protected sheets/ranges in Google Sheets?

Owner of the spreadsheet

Editor

Viewer

All of the above.

Answer

Correct Answer: Owner of the spreadsheet

Note: This Question is unanswered, help us to find answer for this one

3.
Suppose you send out a form to others for collecting their responses. If you choose New Google
Forms option for collecting the responses, then which of the following options can be used as the storage destination?

New spreadsheet

Enter in an existing spreadsheet

New sheet in an existing spreadsheet

Keep responses only in Forms

Answer

Correct Answer:

Enter in an existing spreadsheet

Note: This Question is unanswered, help us to find answer for this one

4. While performing conditional formatting in a Google Sheets spreadsheet, a test rule containing p’r can format the cells containing which of the following options?

pqr

pqqr

Answer

Correct Answer: pqqr

Note: This Question is unanswered, help us to find answer for this one

5. For multiple users working on the same Google Sheets spreadsheet, which of the following options can enable a back and forth conversation about a cell without changing that cell's content?

Comment

Note

Either Comment or Note

None of these

Answer

Correct Answer: Comment

Note: This Question is unanswered, help us to find answer for this one

6. Suppose you want to ensure that the values entered in the particular column of a table are between 10 to 50 and any other value. if entered. is rejected or a warning message is displayed by Google Sheets. Which of the following procedures should you use?

Click on Format menu on the menu bar -> Select Custom number format option -> Select Criteria as Number and enter values 10 and 50 -> Apply other required settings and click Save.

Select the column —> Click on Data menu on the menu bar -> Select Validation... option -> Select Criteria as Number and enter values 10 and 50 -> Apply other required settings and click Save.

Click on Format menu on the menu bar -> Select Conditional formatting option -> Select Criteria as Number and enter values 10 and 50 -> Apply other required settings and click Save.

Both options b and c can be used.

Answer

Correct Answer: Select the column —> Click on Data menu on the menu bar -> Select Validation... option -> Select Criteria as Number and enter values 10 and 50 -> Apply other required settings and click Save.

Note: This Question is unanswered, help us to find answer for this one

7. Peter entered the first and the last names of the employees of his company in single cells separated by a space. In order to separate the f‌irst and the last names in two columns, which of the following options should he use?

Select the column whose text you wish to split -> Click on Format menu on the menu bar —> Select Text wrapping option -> Select Split text into columns option and select the separator as Space.

Select the column whose text you wish to split -> Click on Format menu on the menu bar -> Select Conditional formatting option -> Select Split text into columns option and select the separator as Space.

Select the column whose text you wish to split -> Click Data menu on the menu bar —> Select Split text into columns option and select the separator as Space.

Select the column whose text you wish to split -> Right Click to open context menu ->Se|ect Split text into columns option and select the separator as Space.

Answer

Correct Answer: Select the column whose text you wish to split -> Click Data menu on the menu bar —> Select Split text into columns option and select the separator as Space.

Note: This Question is unanswered, help us to find answer for this one

8. Which of the following options will you choose to protect a sheet or a range in Google Sheets?

Click Data menu on the menu bar > Click Protected Sheets and ranges option.

Click View menu on the menu bar > Click Protected Sheets and ranges option.

Click Edit menu on the menu bar > Click Protected Sheets and ranges option

Click File menu on the menu bar > Click Protected Sheets and ranges option.

Answer

Correct Answer: Click Data menu on the menu bar > Click Protected Sheets and ranges option.

Note: This Question is unanswered, help us to find answer for this one

9. In google Sheets, conditional cell formatting can be done on the basis of which of the following?

Value

Formula

Image

Both options a and b

Answer

Correct Answer: Both options a and b

Note: This Question is unanswered, help us to find answer for this one

10.
Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool used for wrapping text in Google Sheets?

(i)

(ii)

(iii)

(iv)

Answer

Correct Answer:

(iv)

Note: This Question is unanswered, help us to find answer for this one

11.
Choose the incorrect statement from the following statements.
You can change the number, date or currency formats in your spreadsheet created using Google Drive.

You can add formulas in your spreadsheet created using Google Drive.

You cannot wrap text in your spreadsheet created using Google Drive.

You can insert comments in your spreadsheet created using Google Drive.

Answer

Correct Answer:

You cannot wrap text in your spreadsheet created using Google Drive.

Note: This Question is unanswered, help us to find answer for this one

12. Which of the following functions is used to return the current date and time in Google Sheets?

TODAY()

WORKDAY()

Now()

Both options a and c can be used

Answer

Correct Answer: Now()

Note: This Question is unanswered, help us to find answer for this one

13.
Which of the following operations are possible in the forms created using Google Drive?
1. Edit
2. Delete
3. Duplicate

1 and 2 only

2 and 3 only

1 and 3 only

1, 2 and 3

Answer

Correct Answer:

1, 2 and 3

Note: This Question is unanswered, help us to find answer for this one

14.
Choose True or False.
A spreadsheet uploaded on Google Drive can be edited only when it has been converted to Google Sheets format.

True

False

Answer

Correct Answer:

True

Note: This Question is unanswered, help us to find answer for this one

15. Which of the following options can be used to resize the height of a row in Google Sheets?

Click on Edit menu on the menu bar > Select Resize row... option.

Click on Format menu on the menu bar > Select Resize row... option.

Click on the header for the row to be resized > Drag cursor to expand selection > Right click and choose Resize row... option.

Rows cannot be resized in Google Sheets.

Answer

Correct Answer: Click on the header for the row to be resized > Drag cursor to expand selection > Right click and choose Resize row... option.

Note: This Question is unanswered, help us to find answer for this one

16. Which of the following sections of the Report Editor window of Pivot table... menu option is edited for adding a Calculated Field to a pivot table in Google Sheets?

Values

Columns

Rows

Filter

Answer

Correct Answer: Values

Note: This Question is unanswered, help us to find answer for this one

17.
Given is a screenshot of a Google Sheets spreadsheet in which Column D with header row C2. has been generated by dividing column B value by column C value using function ARRAYFORMULA(B2:B/C2:C). Some of the column 8 entries do not have corresponding column C entries; in that case #DlV/O! is being displayed as an error message in column D since second parameter in ARRAYFORMULAO function cannot be 0. Which of the following options will avoid this error?

NA(ARRAYFORMULA(B2:B/C2:C))

ISERROR(ARRAYFORMULA(82:B/C2:C))

ARRAYFORMULAlIFERROR((82:B/C2:C))

There is no solution to this problem as ARRAYFORMULA does not accept an empty second

parameter.

Answer

Correct Answer:

ARRAYFORMULAlIFERROR((82:B/C2:C))

Note: This Question is unanswered, help us to find answer for this one

18. Which of the following would you use if you want different people to view the data differently in your spreadsheet in Google Sheets?

Filter

Pivot table

Filter views..

View

Answer

Correct Answer: Filter views..

Note: This Question is unanswered, help us to find answer for this one

19. In which of the following views of Google Sheets spreadsheet are we not able to select cells. Rename sheets or charts using Google Drive on the web?

Normal spreadsheet

List

Gridline

All of the above.

Answer

Correct Answer: List

Note: This Question is unanswered, help us to find answer for this one

20.
Which of the following options can be used to sort a named range in a Google Sheets spreadsheet?
1. Select range of cells to sort > Click on Data menu on the menu bar > Select Sort range... option.
2. Select range of cells to sort > Right click to open context menu > Select Sort range... option.
3. Select range of cells to sort > Click on empty cell above Row 1 and before column A > Right click to open context menu > Select Sort range... option.
4. Select range of cells to sort > Click on Format menu on the menu bar > Select Sort range... option.

Only options 2, 3 and 4

Only options 1, 2 and 3

Only option 3

Only option 2

Answer

Correct Answer:

Only options 2, 3 and 4

Note: This Question is unanswered, help us to find answer for this one

21. In order to insert an image inside a particular cell in a Google Sheets spreadsheet. which of the following options can be used?

The image is inserted using IMAGE function.

Click on the cell in which you wish to insert the image -> Click on the Insert menu option on the menu bar —> Click Image... option -> Click button Choose an image to upload —> Select the image and click Open.

Right click on the cell in which you wish to insert the image -> Select image... option from context menu -> Click button Choose an image to upload -> Select the image and click Open.

Any of the above options can be used.

Answer

Correct Answer: Any of the above options can be used.

Note: This Question is unanswered, help us to find answer for this one

22. Which of the following options should be used if you want to name a range of cells in a Google Sheets spreadsheet?

Click on Data menu on the menu bar -> Select Named Ranges option -> Enter a desired name and click Done button.

Click on Insert menu on the menu bar -> Select Named Ranges option -> Enter a desired name and click Done button.

Click on View menu on the menu bar -> Select Named Ranges option -> Enter a desired name and click Done button.

Such a feature is not available in Google Sheets.

Answer

Correct Answer: Click on Data menu on the menu bar -> Select Named Ranges option -> Enter a desired name and click Done button.

Note: This Question is unanswered, help us to find answer for this one

23. Which of the following actions can be performed with Google Sheets using Google Drive?

You can import and convert .xls. .xlsx, .csv, .txt and .ods formatted data to a Google spreadsheet.

You can export .xls, .xlsx, .csv, .txt and .ods formatted data, as well as PDF and HTML files.

You can use formula editing to perform the calculations.

You can embed the spreadsheet on a blog or a website.

All of the above.

Answer

Correct Answer: All of the above.

Note: This Question is unanswered, help us to find answer for this one

24. Which of the following is correct regarding movement of a row in Google Sheets?

If a row is dragged and moved to a new location in a spreadsheet, the row at the target location and the rows above it get shifted one position up.

A single row can be moved but a group of subsequent rows cannot be moved in a spreadsheet.

If a row is moved to the location of another row in a spreadsheet. both rows get swapped.

A row can be moved at the most ten positions below its current position in a spreadsheet.

Answer

Correct Answer: If a row is dragged and moved to a new location in a spreadsheet, the row at the target location and the rows above it get shifted one position up.

Note: This Question is unanswered, help us to find answer for this one

25.
The sum of squares of numbers 10, 12. and values of cells from B2 to B4 is to be generated in a GoogleSheets spreadsheet. Which of the following is/are the correct form of the function to be used to generate the sum?
1. =SUMSQ(10,12,82-84)
2. =SUMSQ (10.12.82.84)
3. =SUMSO(B2:B4,10,12)
4. =SUMSQ(10,12.82:B4)

Only option 4 is correct.

Both options 1 and 4 are correct.

Both options 3 and 4 are correct.

Both options 2 and 4 are correct.

Answer

Correct Answer:

Only option 4 is correct.

Note: This Question is unanswered, help us to find answer for this one

26. Which of the following statements about Annotations in Google Sheets is correct?

Annotations are the text notes that can be attached to charts.

Annotations are the text notes that can be attached to images.

Annotations are the text notes that can be attached to comments.

Annotations are the text notes that can be attached to drawings.

Answer

Correct Answer: Annotations are the text notes that can be attached to images.

Note: This Question is unanswered, help us to find answer for this one

27.
Choose True or False.
If you have Google Drive installed on your computer and you are creating a spreadsheet in the Google Drive on the web, then the spreadsheet will also be automatically saved to your local hard drive.

True

False

Answer

Correct Answer:

True

Note: This Question is unanswered, help us to find answer for this one

Google Sheets MCQs | Topic-wise

MCQ on Basic Google Sheets

General Google Sheets MCQs

Google Sheets Subjects

More Resources

Google Sheets MCQ

Google Sheets Skill Assessment

Google Sheets PDF

Related MCQs

Google Slides MCQs

Google Web Toolkit MCQs

Hadoop MCQs

Hibernate MCQs

HTML MCQs

Basic Google Sheets MCQ

1. A single spreadsheet document is often called a ____.

2. Who is allowed to set editing permissions for protected sheets/ranges in Google Sheets?

3. Suppose you send out a form to others for collecting their responses. If you choose New GoogleForms option for collecting the responses, then which of the following options can be used as the storage destination?

4. While performing conditional formatting in a Google Sheets spreadsheet, a test rule containing p’r can format the cells containing which of the following options?

5. For multiple users working on the same Google Sheets spreadsheet, which of the following options can enable a back and forth conversation about a cell without changing that cell's content?

6. Suppose you want to ensure that the values entered in the particular column of a table are between 10 to 50 and any other value. if entered. is rejected or a warning message is displayed by Google Sheets. Which of the following procedures should you use?

7. Peter entered the first and the last names of the employees of his company in single cells separated by a space. In order to separate the f‌irst and the last names in two columns, which of the following options should he use?

8. Which of the following options will you choose to protect a sheet or a range in Google Sheets?

9. In google Sheets, conditional cell formatting can be done on the basis of which of the following?

10. Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool used for wrapping text in Google Sheets?

11. Choose the incorrect statement from the following statements.You can change the number, date or currency formats in your spreadsheet created using Google Drive.

12. Which of the following functions is used to return the current date and time in Google Sheets?

13. Which of the following operations are possible in the forms created using Google Drive?1. Edit2. Delete3. Duplicate

14. Choose True or False.A spreadsheet uploaded on Google Drive can be edited only when it has been converted to Google Sheets format.

15. Which of the following options can be used to resize the height of a row in Google Sheets?

16. Which of the following sections of the Report Editor window of Pivot table... menu option is edited for adding a Calculated Field to a pivot table in Google Sheets?

18. Which of the following would you use if you want different people to view the data differently in your spreadsheet in Google Sheets?

19. In which of the following views of Google Sheets spreadsheet are we not able to select cells. Rename sheets or charts using Google Drive on the web?

21. In order to insert an image inside a particular cell in a Google Sheets spreadsheet. which of the following options can be used?

22. Which of the following options should be used if you want to name a range of cells in a Google Sheets spreadsheet?

23. Which of the following actions can be performed with Google Sheets using Google Drive?

24. Which of the following is correct regarding movement of a row in Google Sheets?

26. Which of the following statements about Annotations in Google Sheets is correct?

27. Choose True or False.If you have Google Drive installed on your computer and you are creating a spreadsheet in the Google Drive on the web, then the spreadsheet will also be automatically saved to your local hard drive.

3.
Suppose you send out a form to others for collecting their responses. If you choose New Google
Forms option for collecting the responses, then which of the following options can be used as the storage destination?

10.
Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool used for wrapping text in Google Sheets?

11.
Choose the incorrect statement from the following statements.
You can change the number, date or currency formats in your spreadsheet created using Google Drive.

13.
Which of the following operations are possible in the forms created using Google Drive?
1. Edit
2. Delete
3. Duplicate

14.
Choose True or False.
A spreadsheet uploaded on Google Drive can be edited only when it has been converted to Google Sheets format.

27.
Choose True or False.
If you have Google Drive installed on your computer and you are creating a spreadsheet in the Google Drive on the web, then the spreadsheet will also be automatically saved to your local hard drive.