Google Sheets Midterm Quiz - 21/10/2024

Which GS formula would you use to add up values in cells A1 through A10?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUMIF(A1:A10)

What will happen if you use =A1+A2 in a cell and A1 contains "5" while A2 contains "3"?

• It will concatenate the values to "53"

• It will add the values to get 8

• It will return an error

• It will return the value of A2

What does the =IF(A1>10, "High", "Low") function do?

• Checks if A1 is less than 10

• Returns "High" if A1 is greater than 10, otherwise "Low"

• Returns "Low" if A1 is greater than 10

• Checks if A1 equals 10

Which of the following is the correct way to multiply values in A1 and A2 in GS?

• =A1 x A2

• =MULTIPLY(A1, A2)

• =A1 * A2

• =A1 / A2

What does =SUM(A1:A10)/COUNT(A1:A10) calculate?

• The sum of A1 to A10

• The median of A1 to A10

• The average of A1 to A10

• The mode of A1 to A10

What will be the output of =IF(OR(A1>10, AND(B1<5, C1>3)), "Pass", "Fail") if A1 is 8, B1 is 4, and C1 is 4?

• Pass

• Fail

• Error

• No output

What will be the result of =IF(A1=10, A1*2, A1+2) if A1 contains 8?

• 12

• 16

• 8

• 10

How does =COUNTA(A1:A10) function differ from =COUNT(A1:A10)?

• COUNTA counts only numbers while COUNT counts all values

• COUNTA counts all non-blank cells, while COUNT counts only numbers

• Both count only numbers

• Both count all cells

What will =IF(AND(A1=10, OR(B1=5,C1=3)), "Match", "No Match") return if A1 is 10, B1 is 4, and C1 is 3?

• Match

• No Match

• Error

• 10

Which function is used in Google Sheets to check if all arguments are TRUE?

• =IF()

• =ISALL()

• =AND()

• =OR()