USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=If()
|
|
|
=Sum()
|
|
|
=SumIf()
|
|
|
=TrueFalse()
|
Detailed explanation-1: -Answer. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.
Detailed explanation-2: -A11: A: =If() This is probably the most powerful function in Excel or any spreadsheet. It will show different results depending if the conditions were answered.
Detailed explanation-3: -The FIND and SEARCH functions are very similar. They both work in the same way-locate a character or a text string in another text string. The difference between these two functions is that FIND is case-sensitive, and SEARCH is not case-sensitive. So if you don’t want to match case in a text string, use SEARCH.
Detailed explanation-4: -One IF function has one test and two possible outcomes, TRUE or FALSE. Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes.