USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Prize
|
|
|
No Prize
|
|
|
Nothing would show in the cell
|
|
|
None of the above
|
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: -Click on “Insert Function” and select the IF function. Our goal here is to have the function display “Yes” if the result is greater than ten, and “No” otherwise. The logical test will tell us whether the function should display “Yes” or “No". If it is true, the function will display “Yes".
Detailed explanation-3: -=IF(B6=29, ”Try again!”, ”You win!”)
Detailed explanation-4: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE. Value if true (optional argument) – The value that will be returned if the logical test evaluates to TRUE.