Excel - Formulas and Functions

........................... are pre-designed formulas in Excel used to perform calculations.

The ........................... function rounds a number to the nearest integer.

The ........................... function is used to display the current date.

The ........................... function finds the largest number in the given range.

A ........................... formula has only one type of operator.

Three types of cell references

• Relative

• Absolute

• Mixed

• All of the above

The _________ reference occurs when a formula in a cell refers to its own cell value directly or indirectly.

The _____ function is used to join two or more than two strings together.

_____________ fubnction returns square root of a number.

______function calculates the greatest common divisor or highest common factor of two or more integers.