DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If a formula is written in excel as =8^6+(3*5) which calculation will Excel make second?
|
exponentiation
|
|
multiplication & division
|
|
addition & subtraction
|
|
parenthesis
|
Explanation:
Detailed explanation-1: -Excel calculates the formula from left to right, according to a specific order for each operator in the formula. If you combine several operators in a single formula, Excel performs the operations in the order shown in the following table.
There is 1 question to complete.