Google Sheets Quiz # 2

In Google Sheets. which of the following options would you select if you want to keep the f‌irst row of a spreadsheet visible even when you scroll down to the 250th row of the same spreadsheet?

Lock

Freeze

Static

Tracker

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)

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

In Google Sheets, which of the following options is not available to a user who has editing permission on a protected sheet?

Set editing permission for protected sheet/range.

Make a copy of the spreadsheet.

Removing editing permission for owners.

None of the above.

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.

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.

Consider the four columns in a Google Sheets spreadsheet having titles colA, coIB, coIC and coID respectively. If you want to execute a query on these columns having a group by clause, then what will be the correct syntax for the query?

=QUERY(Sheet1!1:1000,"select colA,colB,colD group by COD")

=QUERY(Sheet1!1:1000,"se|ect colD,max(colC) group by colD,colC")

=QUERY(Sheet1!1:1000,"select colD,max(colC) group by colD")

=QUERYlSheet1!1:1000,"select colD,colC group by colD,coIA,colB")

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.

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

Which of the following options is correct regarding Find and replace feature in Google Sheets?

You cannot search across multiple spreadsheets.

You can search within formulas.

You can search within specif‌ic range.

None of the above

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

pr

pqqr

Pq

Qr

Which of the following options allow you to turn off the filter in a Google Sheets spreadsheet?

Click Filter icon on the toolbar.

Click Data menu on the menu bar > Click Filter option to turn off the f‌ilter.

Click Tools menu on the menu bar > Click Filter option to turn off the f‌ilter.

Press keyboard shortcut Ctrl + F.

In Google Sheets, which of the following options will allow you to remove all the data validations applied on a worksheet in one go?

Select the complete sheet -> Right click anywhere in the sheet —> Select Protect Range... option -> Click Remove validation button.

Select the complete sheet —> Click on Data menu on the menu bar —> Select Validation... option —> Click Remove validation button.

Select the complete sheet -> Click on Edit menu on the menu bar -> Select Data Validation... option -> Click Reset Iink

Select the complete sheet -> Right click anywhere in the sheet -> Select Data Validation... option -> Click Remove validation button.

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

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

Owner of the spreadsheet

Editor

Viewer

All of the above.

A single spreadsheet document is often called a ____.

Insert

Shareware

Worksheet

Microsoft Paint

Spreadsheets are particularly useful for ____

Desktop Publishing

Hard disk backup software

What If analysis

All of the above

Quiz:	Google Sheets Quiz # 2
Total Questions:	47 MCQs
Time:	47 Minutes