USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A1>75
|
|
|
PASSED
|
|
|
NOT PASS
|
|
|
THERE ARE NO CORRECT ANSWERS
|
Detailed explanation-1: -=IF(C5<70, “Fail", "Pass") Here, C5 is the Marks of Maths. Here, this formula denotes if Marks is less than 70 then the result will be Fail otherwise Pass. Afterward, click the Enter button to see the result. In this case, we can see that the result is ‘Pass’ as the Marks (82) is greater than 70.
Detailed explanation-2: -IF function is also known as logical tests because it is used to test a logical condition. It allows you to perform the comparisons between two values and returns results in one value, either TRUE or FALSE. For example, if you want to pass the exam, then score marks above 60. =IF(marks>60, "Pass", "Fail").
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, "")