DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
average
|
|
|
round
|
|
|
if
|
|
|
vlookup
|
Detailed explanation-1: -Expert-Verified Answer. A function is said to be logical if the function is used to make decision based on stated conditions and comparison. Of the 4 options, the logical function is the IF function.
Detailed explanation-2: -Excel logical functions-overview. Microsoft Excel provides 4 logical functions to work with the logical values. The functions are AND, OR, XOR and NOT. You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one.
Detailed explanation-3: -The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Detailed explanation-4: -A logical test is used in logical functions to evaluate the contents of a cell location. The results of the logical test can be either true or false. For example, the logical test C7 = 25 (read as “if the value in cell C7 is equal to 25”) can be either true or false depending on the value that is entered into cell C7.