FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

The sequence in which calculations in a formula are performed is called?

A	Math
B	Exponents
C	Algebra
D	Order of Operation

Explanation:

Detailed explanation-1: -The order of operations is a rule that tells the correct sequence of steps for evaluating a math expression. We can remember the order using PEMDAS: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right).

Detailed explanation-2: -Rules of Ordering in Mathematics-BODMAS Brackets (parts of a calculation inside brackets always come first). Orders (numbers involving powers or square roots). Division. Multiplication.

Detailed explanation-3: -First, we solve any operations inside of parentheses or brackets. Second, we solve any exponents. Third, we solve all multiplication and division from left to right. Fourth, we solve all addition and subtraction from left to right.

Detailed explanation-4: -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: -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.

There is 1 question to complete.