Google Sheets Formula

Question 1

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

Accepted Answer

$B$2

Answer

B:2

Answer

B2

Answer

#B2

Question 2

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

Accepted Answer

50000

Answer

32364

Answer

65536

Answer

18730

Question 3

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

Accepted Answer

Arguments

Answer

Functions

Answer

Sub functions

Answer

Formulas

Question 4

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

Accepted Answer

Filters

Answer

Sorting

Answer

Statics

Answer

Reporting

Question 5

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

Accepted Answer

@

Answer

*

Answer

^

Answer

/

Question 6

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

Accepted Answer

Clear Formatting

Answer

Clear Styles

Answer

Clear

Answer

Clear all

Question 7

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

Accepted Answer

Automatic

Answer

Currency

Answer

Time

Answer

Number