Excel Formulas (Count,couna,countb, max, min, countif)

= MAX(RANGE) is the syntax for which of the following functions?

• MAX

• MIN

• COUNT

• COUNTIF

Which of the following is the correct syntax for the MIN Function?

• = MAX(RANGE)

• = MIN(RANGE)

• =COUNTIF(range, criteria )

• =COUNT(RANGE)

Which of the following is the correct syntax for the COUNTIF Function?

• =COUNTIF(range, criteria )

• =COUNT(RANGE)

• =COUNTA(RANGE)

• =COUNTBLANK(RANGE)

The Excel MAX function can tell you what the ______numeric value is in a range of cells.

• Smallest

• Largest

• Medium

• Average

The ________ Function it only counts cells containing numbers. All other cells will be ignored (texts, dates, blanks).

• count

• countblank

• counta

• max

If you want to count cells with any type of data (and not just numbers), simply replace COUNT by________ .

• countblank

• counta

• countb

• max

__________________will count the number of empty cells in a given range of cells.

• countblank

• counta

• countb

• max

The Microsoft Excel ___________function counts the number of cells in a range, that meets a given criteria.

• counta

• countif

• count

• countblank

Which of the following is the correct Syntax for the COUNT function?

• =COUNTIF( range, criteria )

• =COUNTBLANK(range)

• =COUNT(range)

• =COUNTA(range)

When copied across multiple cells, they change based on the relative position of rows and columns.

• Relative Cell Reference

• Absolute Cell Reference

• Mixed Cell References

• Normal Cell References