Question

E. Answer the following:
1. What is a Formula? Explain with the help ofan example.

​

Answer 1

Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3. In this formula, SUM is the function of the formula.

Answer 2

A formula is an expression which tells us to perform upon specific value.