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.

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

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?

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 Google Sheets, what is the use of the icon that is shown in the given image?

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

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?

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?

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

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

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