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

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

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

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

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

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?

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?

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?

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

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?

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?