> > Google Sheets MCQs > Basic Google Sheets MCQs

Basic Google Sheets MCQ

1. Spreadsheets are particularly useful for ____

Desktop Publishing

Hard disk backup software

What If analysis

All of the above

Answer

Correct Answer: What If analysis

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

2. 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

3. 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

4.
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

5. 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.

Answer

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

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

6. 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.

Answer

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

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

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

8. 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

Answer

Correct Answer: You can search within specif‌ic range.

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

9. 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

10. 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

11. 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")

Answer

Correct Answer:

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

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

12. 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

13. 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

14. 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

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

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

15. 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

16.
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

17. 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

Answer

Correct Answer: Freeze

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

18.
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

19. 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

20.
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

21.
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

22. In Google Sheets. which of the following functions works only on a sorted row or column?

VLOOKUP

LOOKUP

MATCH

HLOOKUP

Answer

Correct Answer: LOOKUP

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

23. What is the correct function to be used if you want to replicate and copy data from A2 cell of a sheet called Sheet number 4 to some other sheet within the same spreadsheet in Google Sheets?

=‘Sheet number 4'A2'

=‘Sheet number 4'IA2

=Sheet number 4’A2

=Sheet number 4!'A2'

Answer

Correct Answer: =‘Sheet number 4'IA2

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

24. 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

25. 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

26.

Given is an image of a pie chart depicting prices of three cars as percentage of the total in a Google Sheets spreadsheet. If you want to represent the actual values of car prices instead of the percentages, which of the following options will allow you to make that change?

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Chart types tab > Click Doughnut chart option under the Pie Label.

Select the pie chart and click on the formula bar and write function = VALUE (B2, B3, B4) where 82. 83 and B4 are the f‌ields containing sales of cars ABC. NEW and BEE respectively.

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Chart types tab > Select Values option from the drop-down box.

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Customization tab > Select Value option in the drop-down box in front of the Slice label.

Answer

Correct Answer:

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Customization tab > Select Value option in the drop-down box in front of the Slice label.

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

27.
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

28. 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

29. 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

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

30. If you want to store values 13. 25,100. and 23 in cells A1. A2. A3. and A4 respectively; then which of the following array formats should you be entering in cell A1 to obtain the desired result?

= [13; 25; 100; 23]

=[13. 25,100.23}

= (13: 25: 100: 23)

= (13.25.100.23)

Answer

Correct Answer: = [13; 25; 100; 23]

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

31. John selects and copies a column D10:D13 in Google Sheets. While pasting the contents to cell H8. he selects option Paste special > Paste transpose. Which of the following is correct about pasted contents?

The contents of D10:D13 will be copied to H8:H11.

The contents of D10:D13 will be reversed and copied to H8:K8.

The contents of D10:D13 will be copied to H8:K8.

The contents of D10:D13 will be added up and their average will be pasted in cell H8.

Answer

Correct Answer: The contents of D10:D13 will be copied to H8:K8.

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

32. 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

Correct Answer: Both options a and b can be used

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

33.
In Google Sheets, what is the use of the icon that is shown in the given image?

To apply border to a table.

To change direction of text from right to left in a cell.

To change direction of spreadsheet grid from right to left.

To create new Filter view.

Answer

Correct Answer:

To change direction of spreadsheet grid from right to left.

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

34. Peter entered a value 1041 in a cell and it automatically got converted to the date format by Google Sheets. Which of the following options should he select to avoid this automatic conversion?

Click on the Format menu on the menu bar > Select Number option > Click Plain Text option.

Click on the Format menu on the menu bar > Select Number option > Click Automatic option.

Click on the Format menu on the menu bar > Select Number option > Click Number option.

Click on the Data menu on the menu bar > Select Number option > Click Number option.

Answer

Correct Answer: Click on the Format menu on the menu bar > Select Number option > Click Plain Text option.

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

35. 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

36. By default. what kind of cell reference is used in Google Sheets?

Relative reference

Absolute reference

Mixed reference

Answer

Correct Answer: Relative reference

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

37.
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

38.
Suppose you typed 2 in cell A1 and 5 in cell A2, then selected A1 and A2 cells as shown in the image. If you drag a small blue rectangular box on the right end corner of cell A2 that is highlighted in black circle then what values will be automatically entered in cells A3, A4, A5, and A6 respectively?

6. 7. 8, and 9

2. 2. 2. and 2

5. 5. 5. and 5

8.11.14. and 17

4. 5. 6. and 7

Answer

Correct Answer:

8.11.14. and 17

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

39. 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

40. Jenny wants to store a phone number in the format of plus sign followed by the number in a GoogleSheets spreadsheet(i.e., +012734343344). But when she directly enters phone number as+012734343344 in a cell in the spreadsheet. it gets converted to 012734343344. What can she do to enter the telephone number in the desired format?

Begin the telephone number with a single quote. Example: '+012734343344

Use function CONCATENATE Example: =CONCATENATE("+",012734343344)

Click Format menu on the menu bar > Select Number option > Select More Formats option > Click Custom number format... option and select the format +#, ##O_) ;( $#, ##0)

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

41. 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

42. 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

43. 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

44.
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

45. 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

46.
Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool that automatically generates charts and analysis on the basis of data patterns in your Google sheet?

(i)

(ii)

(iii)

(iv)

Answer

Correct Answer:

(i)

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

47.
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. Spreadsheets are particularly useful for ____

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

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

4. 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?

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

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

7. 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?

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

9. 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?

10. 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?

11. 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?

12. 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?

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

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

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

16. 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?

17. 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?

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

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

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

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

22. In Google Sheets. which of the following functions works only on a sorted row or column?

23. What is the correct function to be used if you want to replicate and copy data from A2 cell of a sheet called Sheet number 4 to some other sheet within the same spreadsheet in Google Sheets?

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

25. 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?

26. Given is an image of a pie chart depicting prices of three cars as percentage of the total in a Google Sheets spreadsheet. If you want to represent the actual values of car prices instead of the percentages, which of the following options will allow you to make that change?

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

29. 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?

30. If you want to store values 13. 25,100. and 23 in cells A1. A2. A3. and A4 respectively; then which of the following array formats should you be entering in cell A1 to obtain the desired result?

31. John selects and copies a column D10:D13 in Google Sheets. While pasting the contents to cell H8. he selects option Paste special > Paste transpose. Which of the following is correct about pasted contents?

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

33. In Google Sheets, what is the use of the icon that is shown in the given image?

34. Peter entered a value 1041 in a cell and it automatically got converted to the date format by Google Sheets. Which of the following options should he select to avoid this automatic conversion?

35. 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?

36. By default. what kind of cell reference is used in Google Sheets?

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

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

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

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

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

46. Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool that automatically generates charts and analysis on the basis of data patterns in your Google sheet?

47. 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.

4.
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?

16.
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?

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

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

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

26.

Given is an image of a pie chart depicting prices of three cars as percentage of the total in a Google Sheets spreadsheet. If you want to represent the actual values of car prices instead of the percentages, which of the following options will allow you to make that change?

33.
In Google Sheets, what is the use of the icon that is shown in the given image?

46.
Given is an image with four icons of the tools used in Google Sheets. Which of the following options corresponds to the tool that automatically generates charts and analysis on the basis of data patterns in your Google sheet?

47.
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.