DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Per the order of operations, which of the following is calculated first?
|
|
Addition (+) and subtraction (-) (left to right)
|
|
|
Exponentiation (ˆ)
|
|
|
Percent (%)
|
|
|
Negative number (-)
|
Explanation:
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: -A formula in Excel always begins with an equal sign (=).
There is 1 question to complete.