g

Formula

Formulas are used to preform mathematical calculations such as addiction subtraction multiplication and division all formula begin with =

Function

Pre built formula in excel

Concayention

Addition of 2 or more text values

Cell range

Cell range is a group of selected cells

A cell range can be used to preform calculations on multiple cells

Cell reference

A cell reference in a formula is known as the cell reference

Relative cell reference

In relative cell referce when you copy the formula to other cells the reference cell gets changed automatically

Absolute reference

It is used when you do not want to change the address of the cell while copying the formula to the other cell

To use it add dollar sign before column and row number

Mixed reference

It is an combination of relative and absolute cell reference.

Either row or column must remain fixed