DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF function
|
|
|
AND function
|
|
|
HLOOKUP function (X, Y, Z)
|
|
|
VLOOKUP function (X, Y, Z)
|
Detailed explanation-1: -Two or more relations can be logically joined using the logical operators AND and OR . Logical operators combine relations according to the following rules: The ampersand (&) symbol is a valid substitute for the logical operator AND . The vertical bar ( | ) is a valid substitute for the logical operator OR .
Detailed explanation-2: -The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Detailed explanation-3: -Nested IF statement to check multiple logical tests Such functions are called nested IF functions. They prove particularly useful when you wish to return different values depending on the logical tests’ results.