Excel basic formula
Summation in Excel
The basic way of adding things is
=A1+B1+C1
Or the use of in built formula
=Sum(A1:C1)
Adding non consecutive cell
=Sum(A1:C1)+D8
Or
=Sum(A1:C1,D8)
Another some function
=Sum(A1:C1)+=Sum(A4:C4)
Substraction in excel
Simple method of substraction is
=A2-C4
Multiplication in excel
=A2*C2
Multiply more than two numbers
A2, B2,C3
Put semi colone notation(:)
=Sum(A2:C3)
Or use product sign
=Product (A2:C3)
Division in Excel
Division of one value to another the slash sign should be used as follows
Take example A2 is filled by 40 and A3 is filled by 10
=A2/A3
The answer is 4
Average in Excel
Here, you are trying to figure a common value. Example of determine the students score marks to all exams lets see these three subjects average
Insert this formula to Average cell E2 as follows
=Average (B2:D2)
Or use average function in function library