SOME TIPS TO EXCEL AT MATHEMATICAL CALCULATIONS.
Answers
To excel at mathematical skills you can just try learning Abacus or Vedic maths .
Really , I have tried it and it's a great help!
Hope you find it useful:)
Answer:
The 5 basic rules to remember as we discuss Excel formulas are:
To begin at the beginning, here are 5 important things you need to know about doing math in Excel.
All Excel formulas start with an equal (=) sign. This tells Excel that it is a formula.
The answer to the formula displays in the cell into which the formula is entered.
Cells are referenced in a formula by their column-row identifier, ie. A1, B2.
The symbols for addition, subtraction, multiplication, and division are: + - * /
You do not have to enter capital letters in your formula; Excel will automatically capitalize them.Example of simple math formulas:
=A1+A6 this Excel formula adds the contents of cell A1 and A6
=A1+A2+A3 this Excel formula adds the contents of the three cells specified. (See the SUM function for adding multiple numbers)
=A3-A1 this Excel formula subtracts the contents of cell A1 from the contents of cell A3
=B2*B3 this Excel formula multiples the numbers in cells B2 and B3
=G5/A5 this Excel formula divides G5 by A5. (NOTE: If you see the error message #DIV/O! in a cell, you are trying to divide by zero or a null value - which is not allowed.)
=G5^2 this formula tells Excel to square the value in cell G5. The number after the caret is the exponent. Likewise, the formula H2^3 would cube the value in cell H2.
We can combine multiple operations in one formula. Make sure you use parentheses where needed or you may not get the correct results (see Order of Operations below). Here are some examples:
=(C1+C3)/C4 This Excel formula adds the value in C1 to the value in C3, and then divides the result by the value in C4
=4*(A2+A5)+3 This Excel formula adds the contents of A2 and A5, multiples this sum by 4, and then adds 3.
Mathematical Order of Operations
Remember the Order of Operations by remembering the phrase Please Excuse My Dear Aunt Sally. The letters stand for: Parentheses, Exponents, Multiplication, Division, Addition, and Subtraction. And all operations are carried out from left to right. Here is how the order is applied:
First, any math inside of parentheses is calculated.
On the second pass, all exponents are resolved.
Then any multiplication OR division is performed.
Lastly, any addition OR subtraction is performed.
Example #1: Let's illustrate with a simple formula: 4+2*3
Since the multiplication must be done first, our expression resolves itself to 4+6=10.
Example #2: How about a slightly harder example: 20÷5+2*3
First we divide, and 20÷5=4. Then we multiply, and 2*3=6. Lastly we add, and 4+6=10.
Example #3: Now we're getting complicated: (2*4)+3^2-8/4
Step 1 - Parentheses: 2*4 = 8. Now our expression reads: 8+3^2-8/4
Step 2 - Exponents: 3^2=9. Now our expression reads: 8+9-8/4
Step 3 - Multiply and Divide: 8/4=2. Now our expression reads: 8+9-2
Step 4 - Add and Subtract: The answer is 15.
Example #4: Now test your skill on a crazy formula! 3^(6/3)+(3*3)-2*(6-3)
Step-by-step explanation:
Please make me at brainlist and follow me and say thanks and rate