FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

For the priority of working on the following mathematical operations which is the first to be done in MS.Excel?

A	* (multiplication)
B	/ (distribution)
C	+ (sum)
D	-(reduction)

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 general mathematical rules for calculations, which is Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction, or the acronym PEMDAS (Please Excuse My Dear Aunt Sally). Using parentheses allows you to change that calculation order.

Detailed explanation-3: -Operator precedence in Excel formulas 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.

There is 1 question to complete.