General MCQ for Google Sheets

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

20. Spreadsheets are particularly useful for ____