FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -When more than one arithmetic operator is involved in a formula, excel follows the same basic order of operations that you use in algebra. An arithmetic operator simply means the mathematical function which takes two operands and then performs a calculation on them.

Detailed explanation-2: -If you combine several operators in a single formula, Excel performs the operations in the order shown in the following table. If a formula contains operators with the same precedence-for example, if a formula contains both a multiplication and division operator-Excel evaluates the operators from left to right.

Detailed explanation-3: -If a formula contains operators with the same precedence-for example, if a formula contains both a multiplication and division operator-Excel evaluates the operators from left to right. To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first.

Detailed explanation-4: -When evaluating a formula, Excel follows a standard math protocol called “order of operations". In general, Excel’s order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet.

Detailed explanation-5: -The arithmetic operator, ^, directs Excel to perform the division operation. Point mode allows you to select cells for use in a formula by using the keyboard. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.