General Google Sheets MCQs

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

27. A spreadsheet uploaded on Google Drive can be edited only when it has been converted to Google Sheets format.

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

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

30. You can change the number, date or currency formats in your spreadsheet created using Google Drive.

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

32. Which options corresponds to the tool used for wrapping text in Google Sheets?

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

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

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

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

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

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

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

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

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

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

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

44. Forms option for collecting the responses, then which of the following options can be used as the storage destination?

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

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

47. Spreadsheets are particularly useful for ____