Functions on MOS Exam Excel

How to find the sum of a group of numbers? (Most used)

Which function looks for certain criteria and sums up those cells (Work backwards in the function dialogue box)?

Counts the number of cells in a range that have numbers in them.

Counts the fields that match a certain criteria.

Returns the largest result from a range of numbers.

Extracts a given number of characters from the middle of a supplied text string.

Combines cells into a new cell.

Returns the smallest result from a range of numbers.

Returns the average result from a range of numbers.

Gets the average of numbers that meet criteria.