MS Excel Functions and Formula

a predefined formula that performs calculations using specific values in a particular order.

• Rank

• Function

• Formula

• Sum

An expression that operates on values in a range of cells or a cell.

• Formula

• Function

• Sum

• Average

It adds all of the values of the cells in the argument.

• Formula

• Function

• Sum

• Average

It calculates the sum of the cells and then divides that value by the number of cells in the argument.

• Formula

• Function

• Sum

• Average

This function is useful for quickly counting items in a cell range.

• Rank

• Max

• Min

• Count

A6:A21 is an example of __________

• cell address

• cell

• cell range

• name box

A15 is an example of ______________

• cell address

• cell

• cell range

• name box

It is where the cell address is written

• cell address

• cell

• cell range

• name box

Which of the following is a symbol for exponents in spreadsheet calculation?

• =

• +

• ( )

• ^

Which function in Excel tells how many numeric entries are there?

• NUM

• COUNT

• IF

• SUM