|Consider the given expression entered in a cell.|
|= 476 + 28 * (100-(10)^2)|
|What would be displayed in the cell when you type the given expression and then press the Enter key?|
Correct Answer: B
Solution :Excel follows the BODMAS rule while evaluating arithmetic expression. So, firstly inner bracket will be solved and then the outer bracket and then the rest as shown here: \[476+28*(100-10\wedge 2)\to 476+28*\left( 100-100 \right)\to 476+28*\left( 0 \right)~\to 476+28*0~\to 476+0~\to 476\]
You need to login to perform this action.
You will be redirected in 3 sec