Excel Functions and Formatting Quiz

What does the COUNTIF function do in Excel?

• Counts the number of cells that contain numbers

• Counts the number of cells that meet a specified condition

• Counts the total number of cells in a range

• Counts the number of empty cells

Which of the following is a correct syntax for the COUNTIF function?

• `=COUNTIF(range, criteria)`

• `=COUNTIF(criteria, range)`

• `=COUNTIF(range)`

• `=COUNTIF(criteria)`

What is the primary purpose of conditional formatting in Excel?

• To format cells based on a condition

• To count the number of cells in a range

• To look up values in a table

• To sum values in a range

Which of the following is NOT a feature of conditional formatting?

• Highlighting cells with specific text

• Changing font colour based on cell value

• Automatically sorting data

• Creating data bars within cells

What does the LOOKUP function do in Excel?

• Finds a value in a table based on a row and column number

• Looks up a value in a single row or column and returns a corresponding value

• Counts the number of cells that contain text

• Formats cells based on a condition

What does the COUNT function do in Excel?

• Counts the number of cells that contain numbers

• Counts the number of cells that contain text

• Counts the number of empty cells

• Counts the number of cells that meet a specified condition

Which of the following is a correct syntax for the COUNT function?

• `=COUNT(range)`

• `=COUNT(range, criteria)`

• `=COUNT(criteria)`

• `=COUNT()`

What does the COUNTA function do in Excel?

• Counts the number of empty cells

• Counts the number of cells that contain numbers

• Counts the number of non-empty cells

• Counts the number of cells that meet a specified condition

Which of the following is a correct syntax for the COUNTA function?

• `=COUNTA(range)`

• `=COUNTA(range, criteria)`

• `=COUNTA(criteria)`

• `=COUNTA()`

If you want to count the number of cells in a range that are not empty, which function would you use?

• COUNT

• COUNTA

• COUNTIF

• LOOKUP