DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How would Excel calculate =(82-32)/5+8*2Hint:PEMDAS
|
|
2.38
|
|
|
26
|
|
|
3.333
|
|
|
17
|
Explanation:
Detailed explanation-1: -Excel follows general mathematical rules for calculations, which is Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction, or the acronym PEMDAS (Please Excuse My Dear Aunt Sally). Using parentheses allows you to change that calculation order.
Detailed explanation-2: -Thus, 26 is the correct answer.
Detailed explanation-3: -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.
There is 1 question to complete.