DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
(lookup ____ value, value ____ if ____ true, ____ value ____ if ____ false)
|
|
|
(logical ____ test, value ____ if ____ true, value ____ if ____ false)
|
|
|
(lookup ____ value, table ____ array, column ____ index, range ____ lookup)
|
|
|
(Rate, Pv)
|
Detailed explanation-1: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.
Detailed explanation-2: -The IF function runs a logical test and returns one value for a TRUE result, and another value for a FALSE result. The result from IF can be a value, a cell reference, or even another formula. By combining the IF function with other logical functions like AND and OR, you can test more than one condition at a time.
Detailed explanation-3: -Arguments can be numbers, text, logical values such as TRUE or FALSE, arrays, error values such as #N/A, or cell references. The argument you designate must produce a valid value for that argument. Arguments can also be constants, formulas, or other functions.