Google Sheets: Working with Functions Quiz

What is a function in Google Sheets?

• A way to create charts

• A method to sort data

• A tool to format cells

• A predefined formula that performs calculations

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

• #

• =

• +

• -

Which function would you use to find the average of a range of cells?

• AVERAGE

• SUM

• MAX

• COUNT

How are multiple arguments separated in a function?

• By a semicolon

• By a space

• By a comma

• By a colon

What does the SUM function do?

• Finds the minimum value

• Adds all the values of the cells

• Counts the number of cells

• Finds the maximum value

Which function would you use to count the number of cells with numerical data?

• MIN

• AVERAGE

• MAX

• COUNT

What is the correct syntax for the AVERAGE function?

• =AVERAGE B1;B9

• =AVERAGE(B1:B9)

• =AVERAGE B1:B9

• =AVERAGE(B1;B9)

What does the MAX function determine?

• The lowest cell value

• The sum of cell values

• The highest cell value

• The average cell value

Where can you find a list of all functions available in Google Sheets?

• In the File menu

• In the Functions button drop-down menu

• In the Edit menu

• In the View menu

What should you do if Google Sheets does not indicate an error in your function?

• Ignore it

• Double-check your formulas

• Restart Google Sheets

• Contact support