Google Sheets Review 1

Why is it necessary to manually adjust the column width sometimes? (more than one answer is true)

• This is the only way to resize a column.

• The title is included in the column and autofit will make the width too wide.

• The data in the columns is too crowded with autofit.

• There are too many rows.

In Google Sheets, formulas always start with an = sign.

• True

• False

In Google Sheets, all formulas that are pre-programmed into the software can be found under this icon.

• filter

• comment

• functions

• border

To AUTOFIT a column in Google Sheets, do the following:

• Drag the line between the columns right or left.

• Do nothing, the program does it on its own.

• Click on the AUTOFILL button.

• Double-click the line to the right of the column you want to resize.

When using the Count function, it is important to remember this (more than one answer is correct).

• Select all of the cells you want the program to count.

• The cells you are using must contain data that IS NOT NUMERIC.

• The program will give you an error if you select cells that do not contain numeric values.

• The cells you are using must contain data that IS NUMERIC.

Before starting a formula in Google Sheets, you should select the cell you want the formula/answer to appear in.

Show Answers

10 secTime Limit

• True

• False

In Google Sheets, the Max formula is used:

• only by anyone who is named Max

• when you want to determine the LARGEST NUMBER in a range of cells

• when you want to determine the SMALLEST NUMBER in a range of cells

• when you want to determine which cells are full

In Google Sheets, the Min formula is used:

• only by anyone who is named Minnie

• when you want to determine the LARGEST NUMBER in a range of cells

• when you want to determine the SMALLEST NUMBER in a range of cells

• when you want to determine which cells are empty

Google Sheets is a spreadsheet program that allows you to create, edit, analyze and manipulate data online.

• True

• False

Google Sheets is a Microsoft program.

• True

• False