Question

Raghav is studying formulas in MS-Excel but is confused between basic and compound formulas. Help him to understand the difference between them by giving an example

Answer 1

Answer:

Formula is an expression that calculates values in a cell or in a range of cells. For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.

Function is a predefined formula already available in Excel.

Explanation: