Google Suite Basics - Google Sheets Formulas

What symbol is used to start a formula in Google Sheets?

• !

• *

• +

• =

What function is used to sum a range of cells in Google Sheets?

• RANGE_SUM()

• ADD()

• SUM()

• TOTAL()

How can you reference a cell in a formula in Google Sheets?

• Refer to the cell by its color

• Click on the cell while typing the formula

• Use the cell's name in the formula

• Type the cell reference directly into the formula using the cell's column letter and row number.

What does the function CONCATENATE do in Google Sheets?

• Changes the font style of text

• Splits text into multiple cells

• Adds up numbers in different cells

• Combines text from multiple cells into one cell.

How can you apply a formula to multiple cells in Google Sheets?

• Manually type the formula into each cell.

• Copy and paste the formula into each cell individually.

• Right-click on the cell and select 'Apply formula to multiple cells'.

• Click and drag the small square at the bottom right corner of the cell with the formula.

What is the purpose of the IF function in Google Sheets?

• The purpose of the IF function in Google Sheets is to format cells.

• The purpose of the IF function in Google Sheets is to calculate averages.

• The purpose of the IF function in Google Sheets is to perform conditional logic.

• The purpose of the IF function in Google Sheets is to insert images.

What does the function AVERAGE do in Google Sheets?

• Finds the maximum value in a range of numbers

• Calculates the average of a range of numbers.

• Multiplies a range of numbers together

• Counts the number of cells in a range that contain numbers

How can you insert a new row in Google Sheets?

• Click on the column header and select 'Insert row'

• Use the 'Delete' function and then manually add a new row

• Copy and paste an existing row to create a new one

• Right-click on the row number and select 'Insert 1 above' or 'Insert 1 below'.

What is the shortcut to auto-fill a series of numbers in Google Sheets?

• Ctrl + Enter (Cmd + Enter on Mac)

• Ctrl + Space

• Alt + Enter

• Ctrl + Shift + Enter

How can you protect a formula in Google Sheets from being edited?

• Share the spreadsheet with everyone

• Change the font color of the formula cells

• Delete the formula

• Lock the cells containing the formula and set permissions to 'View only'.