NEW
Font size
WorksheetsGoogle Suite Basics - Google Sheets Formulas
Total questions: 10
Worksheet time: 5mins
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'.
