FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which function has the syntax (logical ____ test1, value ____ if ____ true1, logical ____ test2, value ____ if ____ true2 ____ )?
A
Nested IF
B
AVERAGEIF
C
IF
D
IFS
Explanation: 

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

Detailed explanation-2: -The IF function is a premade function in Excel, which returns values based on a true or false condition. The condition is referred to as logical test, which can check things like: If a number is greater than another number > If a number is smaller than another number <

Detailed explanation-3: -Top Answer b )Explanation: IN MS Excel, “IF” function is used to check the particular condition. It will return differently depending on the result of the condition was TRUE or FALSE. Thus, option (b) is correct.

Detailed explanation-4: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

There is 1 question to complete.
Previous
Next