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

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?

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

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.