USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In Excel, you can use the ____ function when you want to assign a value to a cell based on a logical test.
|
|
IF THEN
|
|
|
IF
|
|
|
NOW
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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-2: -In Excel, we can perform a logical test for any situation. The most commonly used logical test is using the equals to the operator, which is “=” if we use =A1=B1 in cell A2, then it will return TRUE if the values are equal and FALSE if the values are not equal.
Detailed explanation-3: -LOOKUP() The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column.
There is 1 question to complete.