FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ are often the best way to define which calculations will be performed first in Excel.
A
Parentheses
B
Forumlas
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -In our example, if the parentheses are not included, the multiplication is calculated first and the result is incorrect. Parentheses are the best way to define which calculations will be performed first in a formula.

Detailed explanation-2: -Parentheses are often the best way to define which calculations will be performed first in Excel.

Detailed explanation-3: -Parentheses () is used to change the order of an operation. Using parentheses makes Excel do the calculation for the numbers inside the parentheses first, before calculating the rest of the formula. Parentheses are added by typing () on both sides of numbers, like (1+2) .

Detailed explanation-4: -Operators specify the type of calculation that you want to perform on the elements of a formula.

Detailed explanation-5: -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.
Previous
Next