Mastering Google Sheets Formulas

What is the function used to add up a range of cells in Google Sheets?

• AVERAGE

• SUM

• COUNT

• MAX

Which function would you use to count the number of cells that are not empty in a range?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

How do you apply conditional formatting to highlight cells greater than 100?

Which function would you use to find the average of cells that meet a specific condition?

• AVERAGE

• AVERAGEIF

• SUMIF

• COUNTIF

What is the correct syntax for the SUMIF function?

• SUMIF(range, criteria, [sum_range])

• SUMIF(criteria, range, [sum_range])

• SUMIF([sum_range], range, criteria)

• SUMIF(range, [sum_range], criteria)

Which function would you use to return the smallest number in a range that meets a single condition?

• MIN

• MINIF

• MINIFS

• MINIMUM

How would you format a cell to display currency in Google Sheets?

• Format > Number > Currency

• Format > Number > Percentage

• Format > Number > Date

• Format > Number > Plain Text

Which function would you use to count the number of cells that meet a specific condition?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What is the correct syntax for the IFS function?

• IFS(condition1, value1, condition2, value2, ...)

• IFS(value1, condition1, value2, condition2, ...)

• IFS(condition1, condition2, value1, value2, ...)

• IFS(value1, value2, condition1, condition2, ...)

Which function would you use to return the largest number in a range that meets a single condition?

• MAX

• MAXIF

• MAXIFS

• MAXIMUM