USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Orders or operations
|
|
|
Formulas
|
|
|
Variables
|
|
|
Constants
|
Detailed explanation-1: -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-2: -A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells your spreadsheet which operation to calculate first.
Detailed explanation-3: -Excel follows general mathematical rules for calculations, which is Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction, or the acronym PEMDAS (Please Excuse My Dear Aunt Sally). Using parentheses allows you to change that calculation order.
Detailed explanation-4: -The order of operations tells us the order to solve steps in expressions with more than one operation. 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.
Detailed explanation-5: -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.