USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Manually extract the data
|
|
|
Sort the data
|
|
|
Filter the data
|
|
|
Use Goto option
|
Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -Excel’s “does not equal” operator is simple: a pair of brackets pointing away from each other, like so: “<>". Whenever Excel sees this symbol in your formulas, it will assess whether the two statements on opposite sides of these brackets are equal to one another.
Detailed explanation-3: -The Equal to logical operator (=) can be used to compare all data types-numbers, dates, text values, Booleans, as well as the results returned by other Excel formulas. For example: =A1=B1. Returns TRUE if the values in cells A1 and B1 are the same, FALSE otherwise.