DATABASE FUNDAMENTALS
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 ____
|
|
PASSED
|
|
|
FAIL
|
|
|
“ PASS ”
|
|
|
“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.
There is 1 question to complete.