USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
lookup ____ value
|
|
|
criteria
|
|
|
condition
|
|
|
logical ____ test
|
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: -Value if true is the value that is returned if logical test is TRUE. For example, if this argument is the text string “Within budget” and the logical test argument evaluates to TRUE, then the IF function displays the text “Within budget".
Detailed explanation-3: -Value if true (optional)-the value to return when the logical test evaluates to TRUE, i.e. the condition is met. If omitted, the value if false argument must be defined. Value if false (optional)-the value to return when the logical test evaluates to FALSE, i.e. the condition is not met.