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

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

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?

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?

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?

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?

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?

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?

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

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.

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?