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

John selects and copies a column D10:D13 in Google Sheets. While pasting the contents to cell H8. he selects option Paste special > Paste transpose. Which of the following is correct about pasted contents?

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?

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?

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

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 options corresponds to the tool used for wrapping text in Google Sheets?

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?

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

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

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