Excel - Formulas and Functions

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

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

The (a)   function is used to display the current date.

The (a)   function finds the largest number in the given range.

A (a)   formula has only one type of operator.

Three types of cell references

• Relative

• Absolute

• Mixed

• All of the above

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

The (a)   function is used to join two or more than two strings together.

(a)   fubnction returns square root of a number.

(a)   function calculates the greatest common divisor or highest common factor of two or more integers.