DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Not really
|
|
|
Correct
|
|
|
No
|
|
|
if you use the = sign
|
Detailed explanation-1: -They are used within formulas to instruct Excel to first evaluate that part of the formula that is within the brackets. Whatever is in the bracket will be evaluated first. For example, 10 + 2 *5 will result in 20 because Excel follows the conventional order of operations where multiplication precedes addition.
Detailed explanation-2: -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.
Detailed explanation-3: -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-4: -numbers with parentheses are in cells with “accounting” format and negatives are stored in general or standard number formated cells. To resolve you can change the format of destination cells to accounting using cell formatting as number>accounting.