FREE Google Sheets Formula Questions and Answers

0%

Which Google Sheets command is used to remove formatting from a selected cell?

Correct! Wrong!

Correct Answer: Clear Formatting
The clear formatting command is used to clear the formatting of selected cells.

Steps to clear formatting of selected cells in Google sheets:
Select the cells
Click on the "Format menu"
And then, select "Clear formatting"

In Google sheets, the default format for numbers is ___.

Correct! Wrong!

Correct Answer: Automatic
Automatic is the default format for numbers.

A cell reference that is absolute is which of the following?

Correct! Wrong!

Correct Answer: $B$2
An absolute cell reference is $B$2.

Which term refers to a person's education, income, and occupation?

Correct! Wrong!

Correct Answer: Filters
You can use the Filters to focus the data in your worksheet.

____ is the most characters that can fit in a single cell.

Correct! Wrong!

Correct Answer: 50000
There can be no more than 50,000 characters in a single cell.

The majority of functions in Google Sheets have one or more ____ enclosed in parenthesis.

Correct! Wrong!

Correct Answer: Arguments
In Google sheets, most of the functions contain one or more arguments in parentheses.

Which symbol in Google Sheets is not recognized as a mathematical operator?

Correct! Wrong!

Correct Answer: @
The mathematical operators in Google Sheets are the others; the @ symbol is not one of them.