Google Sheets Check In

Question 1

What does the AVERAGE function do?

Accepted Answer

Returns the average of a range of values

Question 2

Formulas should always begin with a(n) ________.

Accepted Answer

equals sign =

Question 3

A group of cells is called a ________.

Accepted Answer

cell range

Question 4

Which of the following is an absolute cell reference?

Accepted Answer

$A$2

Question 5

What symbol is used to represent multiplication in a formula?

Accepted Answer

*

Question 6

Which of the following symbols is not recognized as mathematical operators within Google Sheets?x

Accepted Answer

@

Question 7

Why would you want to freeze rows in your spreadsheet?

Accepted Answer

To scroll through the spreadsheet while continuing to see the frozen rows

Question 8

Which of the following features allows you to narrow down the data in your worksheet?

Accepted Answer

Filters

Question 9

According to the order of operations, which calculation comes first in the following formula?=3^2/5+(12-3)

Accepted Answer

12-3

Question 10

Which function would you use to add the values of several cells?

Accepted Answer

SUM

Questions 10