Question

How to create a basic formula? Explain with Example.​

Answer 1

Answer:

Create a simple formula in Excel

2) On the worksheet, click the cell in which you want to enter the formula.

3) Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes: ...

3) Press Enter (Windows) or Return (Mac).

Answer 2

Answer:

1. =SUM(number1, [number2], …) ...

2. =SUM(A2:A8) – A simple selection that sums the values of a column.

3. =SUM(A2:A8)/20 – Shows you can also turn your function into a formula. ...

4. =AVERAGE(number1, [number2], …) ...

5. =AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)

6. =COUNT(value1, [value2], …)

Explanation:

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.