FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The following statement is true about the difference between single IF functions and multiple/nested IF functions____
A
single if function has only 1 logical test/cell to be tested, whereas multiple/nested IF functions have more than 1 logical test/cell to test
B
the single IF function syntax cannot be used for multiple/nested IF functions, while the double/nested IF function syntax can be used for single IF functions
C
single IF function has more than 2 commands/conditions, while multiple/nested IF functions have only 1 command/condition
D
single if function has only 2 commands/conditions, while double/nested IF functions have more than 2 commands/conditions
E
no difference
Explanation: 

Detailed explanation-1: -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.

Detailed explanation-2: -To test multiple conditions and return different values based on the results of those tests, you can use the CHOOSE function instead of nested IFs. Build a reference table and a use VLOOKUP with approximate match as shown in this example: VLOOKUP instead of nested IF in Excel.

Detailed explanation-3: -Remarks. While Excel will allow you to nest up to 64 different IF functions, it’s not at all advisable to do so.

Detailed explanation-4: -The AVERAGE and SUM functions are nested within the IF function. You can nest up to 64 levels of functions in a formula. Click the cell in which you want to enter the formula. Excel inserts the equal sign (=) for you.

There is 1 question to complete.
Previous
Next