USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Addition (+) and subtraction (-) (left to right)
|
|
|
Exponentiation (ˆ)
|
|
|
Percent (%)
|
|
|
Negative number (-)
|
Detailed explanation-1: -Explanation: Order of operations tells you to perform multiplication and division first, working from left to right, before doing addition and subtraction.
Detailed explanation-2: -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-3: -The string concatenation operator (&) is not an arithmetic operator, but in precedence, it does fall after all arithmetic operators and before all comparison operators.
Detailed explanation-4: -& operator is not an arithmetic operator The basic arithmetic operations are addition, subtraction, multiplication, and division. There are more arithmetic operators like exponentiation, modulus operations, increment, decrement, etc. *-Multiplication operator. So, And operator is not an arithmetic operator.
Detailed explanation-5: -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.