They are used in equations to pull the data directly from specific cells, allowing for more dynamic calculations.

You can make use of formulas like “=A1+A2” to add the values in cells A1 and A2, or “=A1/B1” to divide the value in cell A1 by the value in cell B1.Ĭell references are used in Excel to refer to specific cells within a spreadsheet. They are used in everyday calculations and can be performed easily in Excel.

Arithmetic operations such as addition, subtraction, multiplication, and division are the most commonly used functions in Excel.