Google Sheets Count Functions Quiz

What is the primary purpose of the COUNT function in Google Sheets?

• To count all unique values

• To count all cells with text values

• To count all blank cells

• To count all cells with numeric values

Which function would you use to count cells that contain any type of value, including text and numbers?

• COUNT

• COUNTBLANK

• COUNTIF

• COUNTA

How does the COUNTIF function differ from the COUNT function?

• COUNTIF counts only blank cells

• COUNTIF counts cells based on a specific criterion

• COUNTIF counts only numeric values

• COUNTIF counts unique values

What must be enclosed in quotes when using the COUNTIF function with a text criterion?

• The range

• The function name

• The criterion

• The cell reference

Which function allows you to count cells that meet multiple criteria?

• COUNT

• COUNTA

• COUNTIF

• COUNTIFS

What logic does the COUNTIFS function use to evaluate multiple criteria?

• NOT logic

• XOR logic

• OR logic

• AND logic

Which function would you use to count cells that contain a specific text pattern using wildcards?

• COUNTIFS

• COUNTA

• COUNT

• COUNTIF

Which function would you use to count the number of unique values in a dataset?

• COUNTUNIQUE

• COUNTA

• COUNT

• COUNTBLANK

What does the COUNTBLANK function specifically count?

• Cells with text values

• Cells with numeric values

• Blank cells

• Cells with unique values

If a cell contains a formula that returns an empty string, how does COUNTBLANK treat it?

• As a non-blank cell

• As a numeric cell

• As a blank cell

• As a unique cell