Common Functions in MS Excel

This function adds all of the values of the cells in the argument

• SUM

• AVERAGE

• MAX

• MIN

This function determines the average of the values included in the argument.

• SUM

• AVERAGE

• MAX

• MIN

This function counts the number of cells with numerical data in the argument.

• COUNTIF

• AVERAGE

• MAX

• COUNT

This function counts the number of cells in a range that match the specified criteria.

• COUNTIF

• AVERAGE

• MAX

• COUNT

This function determines the highest cell value included in the argument.

• COUNTIF

• MIN

• MAX

• COUNT

This function determines the lowest cell value included in the argument.

• COUNTIF

• MIN

• MAX

• COUNT

Write the formula to get the Total of all orders

Write the formula to get the Average

Write the formula to get the Highest Order

Write the formula to get the Lowest Order