DATABASE FUNDAMENTALS
BASICS OF BIG DATA
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
DASEMP
|
|
EPSDAM
|
|
PEMDAS
|
|
PEMDSA
|
Detailed explanation-1: -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. First, any expressions in parentheses are evaluated.
Detailed explanation-2: -Excel follows the BODMAS rules of arithmetic to determine the order in which calculations in any given formula are performed. The order is – Brackets Of, then Division, then Multiplication, then Addition, then Subtraction.
Detailed explanation-3: -Operator precedence If a formula contains operators with the same precedence-for example, if a formula contains both a multiplication and division operator-Excel evaluates the operators from left to right.
Detailed explanation-4: -When performing these operations in a formula, Excel follows certain rules of precedence: Expressions within parentheses are processed first. Multiplication and division are performed before addition and subtraction. Consecutive operators with the same level of precedence are calculated from left to right.