Answer:
This is how to create formula in MS excel:
Explanation:
How do you create a formula and function in Excel?
For example, the formulas =SUM(A1:A2) and SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=). Click the cell where you want the formula.
...
Examples.
Data
'=AVERAGE(A1:B4) Averages all numbers in the range A1:B4 =AVERAGE(A1:B4)
