USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Formulas calculate values in a specific order. A formula in Excel always begins with an equal sign (=). Excel interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.
Detailed explanation-2: -The order of operations can be remembered by the acronym PEMDAS, which stands for: parentheses, exponents, multiplication and division from left to right, and addition and subtraction from left to right. There are no parentheses or exponents, so start with multiplication and division from left to right.
Detailed explanation-3: -Use of parentheses To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Excel calculates multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.
Detailed explanation-4: -In a formula, multiplication is performed before subtraction. In a formula, operations within parenthesis are performed after operations outside parentheses. An absolute reference does not change when the formula is copied or moved to another cell.