Google Sheets 3.3 Review

Abigail is creating a budget spreadsheet in Google Sheets. What symbol must she start with to write a formula?

• -

• *

• =

• +

Harper is calculating the total sales for the week. Which of the following is an example of a function she can use in her spreadsheet?

• =A1+A2+A3

• =SUM(A1:A3)

• A1+A2+A3

• A1:A3

Mia is working on a spreadsheet and wants to ensure that a specific cell reference remains constant, even when she copies the formula to other cells. What type of reference should she use?

• Relative reference

• Absolute reference

• Mixed reference

• Static reference

Priya is organizing a charity event and has a list of donations in cells A2 to A10 in her spreadsheet. What does the formula =COUNT(A2:A10) do?

• Counts the total number of numeric values in the range

• Adds up all the values in the range

• Finds the highest value in the range

• Finds the lowest value in the range

Aria is working on a spreadsheet and notices #DIV/0! in one of the cells. What does this mean?

• Name error

• Division by zero error

• Reference error

• Formatting error

Abigail wants to find the highest score in her math test results. Which function would she use to find the highest number in a range?

• =MAX(A1:A10)

• =SUM(A1:A10)

• =MIN(A1:A10)

• =COUNT(A1:A10)

Grace is checking her exam score in cell B2. What is the correct syntax for an IF statement that checks if her score is greater than or equal to 50?

• =IF(B2>50, “PASS”, “FAIL”)

• =IF(B2>=50, “PASS”, “FAIL”)

• =IF(B2=50, “PASS”, “FAIL”)

• =IF(B2<50, “PASS”, “FAIL”)

Isla is organizing a fruit basket and wants to know how many times “apple” appears in her list of fruits. What function would she use?

• =COUNT(A1:A10)

• =SUM(A1:A10)

• =COUNTIF(A1:A10, "apple")

• =MAX(A1:A10)

Aria is working on a spreadsheet for her business expenses. She accidentally deletes a cell that her total expenses formula refers to. Which error message appears when she checks the formula?

• #VALUE!

• #REF!

• #NAME?

• #DIV/0!

Hannah is working on a spreadsheet and needs to find a specific value in a list of data organized vertically. What function should she use?

• Searches for a value in a horizontal table

• Searches for a value in a vertical table

• Counts the number of cells in a range

• Finds the smallest value in a range