USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Order of operation in Excel
|
|
DASEMP
|
|
|
EPSDAM
|
|
|
PEMDAS
|
|
|
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.
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.
There is 1 question to complete.