Excel Functions Quiz

What does the FILTER function do?

• Filters data based on conditions

• Counts numeric values

• Calculates sums

• Averages data

Which cells are counted by COUNTA?

• Numeric cells

• Blank cells

• Non-empty cells

• Cells matching criteria

What is the syntax of the COUNTIF function?

• =COUNTIF(range, criteria)

• =COUNTIF(criteria, range)

• =FILTER(range, criteria)

• =COUNTA(range)

What does nesting FILTER in COUNT accomplish?

• Finds average values

• Counts only filtered results

• Counts blank cells

• Sorts the dataset

What is the benefit of absolute references?

• They make formulas adaptable for multiple uses.

• They avoid formula repetition errors.

• They allow consistent range selection.

• All of the above.

What does =COUNT(range) do?

• Counts numeric cells only

• Counts all non-empty cells

• Filters the range

• Returns a "Yes" count

Why use COUNTA instead of COUNT?

• To count only blank cells

• To count text and numeric values

• To simplify filtering

• To sort a dataset

What's the result of the formula =FILTER(A1:A10, B1:B10="Pass")?

• "Pass" counts in B1:B10

• Numeric cell count in A1:A10

• Only values in A1:A10 where B1:B10 is "Pass"

• All non-empty cells in A1:A10

What's the outcome of =COUNTA(FILTER(range, range>50))?

• Counts blank cells

• Counts numeric cells greater than 50

• Filters all values

• Counts non-empty cells in filtered results