Quiz – Google Sheets Functions & Charts

Which formula checks if a value is greater than 100 and returns “Yes” if true?

• =IF(A1100, "Yes", "No")

• =IF(A1=100, "Yes", "No")

• =IF(A1<>100, "Yes", "No")

What is the purpose of nesting IF formulas?

• To format cells

• To combine multiple conditions in one formula

• To create charts

• To import data

Which formula returns “Good” if score is above 80 and “Average” if above 50?

• =IF(A1>80, "Good", IF(A1>50, "Average", "Poor"))

• =IF(A150, "Poor", "Good")

• =IF(A1=80, "Good", "Average")

What does the AND function do in Google Sheets?

• Checks if at least one condition is true

• Checks if all conditions are true

• Creates text format

• Filters dates only

Which formula checks if a cell is greater than 100 OR less than 50?

• =OR(A1>100, A1100, A1100, A1<50)

• =OR(A1=100, A1=50)

Which formula counts cells that meet multiple criteria?

• AVERAGEIFS(A1:A10, B1:B10, "East")

• COUNTIFS(A1:A10, ">10", B1:B10, "1000")

• COUNTIF(A1:A10, ">10")

• COUNT(A1:A10)

• =SUM(A2:A10)

What does the LEFT function do?

• Extracts characters from the end of a text

• Extracts characters from the beginning of a text

• Counts text characters

• Sums numeric values

Which function rounds a number to 2 decimal places?

• =ROUND(A1)

• =ROUND(A1, 2)

• =LEFT(A1, 2)

• =COUNT(A1)

Which formula extracts the month from a date?

• =DAY(A1)

• =YEAR(A1)

• =MONTH(A1)

• =HOUR(A1)

How do you calculate days between two dates?

• =A1+B1

• =DATEDIF(A1, B1, "D")

• =COUNT(A1:B1)

• =SUM(A1:B1)