Google Sheet Chapter 4

In a spreadsheet table, the formula "=IF(A1>5, B1+C1, D1-E1)" is an example of:

• If-Then-Else function

• Nested If function

• Countlf function

• Averagelf function

In a spreadsheet table, the formula "=IF(A1>10, "High", IF(A1>5, "Medium", "Low"))" is an example of:

• If-Then-Else function

• Nested If function

• Countlf function

• Averagelf function

In a spreadsheet table, the formula "=IF(A2>10, "Yes", "No")" will output "Yes" if the value in cell A2 is:

• Greater than 10

• Less than 10

• Equal to 10

• Any value

In a spreadsheet table, which function allows you to evaluate multiple conditions in a single formula?

• If-Then-Else

• Nested If

• Countlf

• Averagelf

In a spreadsheet table, the function "=COUNTIF(A1:A10, ">5")" will count the number of cells in range A1 to A10 that are:

• Equal to 5

• Less than 5

• Greater than 5

• Any value

In a spreadsheet table, the function " =COUNTIF(A1:A10, "<>0") " will count the number of cells that is not equal to zero in cell:

• A1 and A10

• A1 or A10

• A1 to A10

In a spreadsheet table, the formula " =IF(A1>10, B1, IF(A1>5, C1, D1)) " will output the content of C1 if A1 equals

• 11.

• 4.

• 6.

• 5.

In a spreadsheet table, the function "=COUNTIF(A1:A5, ">=50")" will output 2 if the content of A1 to A5 are

• 50,49,48,47,46

• 51,50,49,48,47

• 52,51,50,49,48

• 53,52,51,50,49

In a spreadsheet table, the formula " =IF(OR(A1="Apple", A1="Banana"), "Fruit", "Not a Fruit") " will output "Fruit" if A1 =

• Pineapple

• Apple

• Banana

• Avocado

4. Which formula would you use to display "Pass" in the corresponding cell if the value in cell B2 is greater than or equal to 60?

• =IF(B2<60, "Pass", "Fail")

• =IF(A3>=60, "Pass", "Fail")

• =IF(A2>=60, "Pass", "Fail")

• =IF(B1>=60, "Pass", "Fail")