FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which includes the formula for the correct IF writing is ____
A
=IF (Comparison; Value if true; Value if false)
B
= IF (Comparison:Value if true:Value if false)
C
= IF (Comparison, Value if true:Value if false)
D
= IF [Comparison; Value if true; Value if false]
Explanation: 

Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-2: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE. Value if true (optional argument) – The value that will be returned if the logical test evaluates to TRUE.

Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-4: -The FALSE function in Excel is equivalent to the number 0.

There is 1 question to complete.
Previous
Next