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?

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?

Which of the following sections of the Report Editor window of Pivot table... menu option is edited for adding a Calculated Field to a pivot table in Google Sheets?

Which of the following options can be used to resize the height of a row in Google Sheets?

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?

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.