Question

What is formula ? Explain about the different types of categorisation of formula used in spreadsheet.
​

Answer 1

Answer:

In Microsoft Excel, formulas perform calculations or other actions on data. Formulas range from basic mathematical operations, such as addition and subtraction, to complex engineering and statistical calculations.

Formulas can contain values, constants, cell references, functions, and operators. Here's a brief look at these components and what they mean.