DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To select the non-adjacent cells, press Shift+F8. This, in turn, enables the Add or Remove Selection mode. Now, use the arrow keys to move the selection and select the cells you want.
Detailed explanation-2: -The IF function is useful when you want to assign a value to a cell based on a logical test. Goal seeking assumes you can change the value of multiple cells referenced directly or indirectly to reach a specific goal for a value of another cell.
Detailed explanation-3: -Which of the following is true about entering a function using the Insert Function dialog box? You can select a function you’ve recently used.
Detailed explanation-4: -"if expression: statement(s)” is the syntax for if statement.
There is 1 question to complete.