FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In Microsoft Excel, for example, cell B5 is written with the formula: IF(B5>=90;”PASS”;”FAILED”), if B5 contains the number 90, then the contents of the cell in D5 are ____
A
PASSED
B
FAIL
C
“ PASS ”
D
“FAILED”
Explanation: 

Detailed explanation-1: -The correct answer is Cell address.

Detailed explanation-2: -Using the setup in Unais’ screenshot: =IF(AND(COUNTIF($B2:$D2, ">=50")=3, COUNTIF($E2:$G2, ">=50")>0), "Pass", "Fail") or more of the same =IF(COUNTIF($B2:$D2, ">=50")/3+COUNTIF($E2:$G2, ">=50")/1>=2, "Pass", "Fail") .

Detailed explanation-3: -Microsoft Excel formulas-the basics After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.

Detailed explanation-4: -If cell contains specific text, then return a value Select the output cell, and use the following formula: =IF(cell="text", value to return, “"). For our example, the cell we want to check is A2, the text we’re looking for is “example”, and the return value will be Yes.

There is 1 question to complete.
Previous
Next