Google Sheets MCQs (Chapterwise Multiple Choice Questions)

In Google Sheets. which of the following keyboard shortcuts is used to add a line break within a cell for a Windows system?

Ctrl + Enter

Alt + Enter

Ctrl + L

Both options a and b can be used

Answer & Explanation

Correct Answer: Both options a and b can be used

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

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.

Answer & Explanation

Correct Answer: Set editing permission for protected sheet/range.

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

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

Answer & Explanation

Correct Answer: pqqr

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

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 & Explanation

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

A single spreadsheet document is often called a ____.

Insert

Shareware

Worksheet

Microsoft Paint

Answer & Explanation

Correct Answer: Worksheet

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

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 & Explanation

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

If a cell is copied and pasted to new cell using Paste special > Paste format only option in Google Sheets, what will happen to the new cell?

Only the cell formatting will be pasted in the new cell and not the values or formulas from the copied cell.

Only conditional formatting will be pasted in the new cell from the copied cell.

Borders, if any, applied on the copied cell will not be applied to the new cell.

Answer & Explanation

Correct Answer: Only conditional formatting will be pasted in the new cell from the copied cell.

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

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 & Explanation

Correct Answer: Both options a and b

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

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 & Explanation

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

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 & Explanation

Correct Answer: Filter views..

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

Google Sheets Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.