USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When Excel follows the order of operations, the formula, 8* 3 + 2, equals ____
|
40
|
|
26
|
|
48
|
|
13
|
Explanation:
Detailed explanation-1: -The order of operations for Excel is as follows: Evaluate items in parentheses. Evaluate ranges (:). Evaluate intersections (spaces).
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.
There is 1 question to complete.