Google Sheets

Google Sheets saves your changes automatically.

• TRUE

• FALSE

A group of cells is called a ________.

• multicell

• cell range

• chart

• cell cluster

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

• Filters

• Relative cell references

• Sorting

• Merge cells

Why would you want to freeze rows in your spreadsheet?

• To modify only the frozen rows

• To prevent the rows from being edited by collaborators

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

• To limit the data that can be entered in the frozen row

Formulas should always begin with a(n) ________.

• hashtag

• dollar sign

• header

• equals sign

What symbol is used to represent multiplication in a formula?

• *

• +

• -

• /

What does the AVERAGE function do?

• Adds a range of values

• Divides a range of values

• Returns the average of a range of values

• Multiplies a range of values

Which of the following symbols are recognized as mathematical operators within Google Sheets? Select all that apply.

• x

• ^

• /

• +

• *

What is the difference between "edit" and "comment" access in Google Sheets?

• Users with "edit" access can only leave comments, while users with "comment" access can make changes to the file.

• Users with "edit" access can make changes to the file, while users with "comments" access can only leave comments.

• Only the file owner can leave comments or make changes to the file.

• "Edit" and "comment" provide the same level of access to the file.

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

• SUM

• AVERAGE

• TOTAL

• MAX