# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### BASICS OF BIG DATA

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Order of operation in Excel
 A DASEMP B EPSDAM C PEMDAS D PEMDSA
Explanation:

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.

There is 1 question to complete.