DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It’s not important because the result is always the same.
|
|
|
It looks more professional.
|
|
|
It significantly changes the results of a formula.
|
|
|
Only accountants use parentheses in their formulas.
|
Detailed explanation-1: -It’s especially important to follow the order of operations when creating a formula. Otherwise, Excel won’t calculate the results accurately. In our example, if the parentheses are not included, the multiplication is calculated first and the result is incorrect.
Detailed explanation-2: -When evaluating a formula, Excel follows a standard math protocol called “order of operations". 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.
Detailed explanation-3: -In some cases, the order in which a calculation is performed can affect the return value of the formula, so it’s important to understand how the order is determined and how you can change the order to obtain the results you want.
Detailed explanation-4: -Excel calculates from left to right, using the PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) order of operations. In other words, it performs calculations in parentheses first, then it checks for multiplication and division, then finally it performs addition and subtraction.