70-448 · Question #157
70-448 Question #157: Real Exam Question with Answer & Explanation
The correct answer is D. =iif(ColumnNumber(Nothing) Mod 2, " lightblue ", "White") would be used for each text box.. IIf(expr, truepart, falsepart) All three parameters are required: expr is the expression that is to be evaluated. truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr retur
Question
Options
- A=iif(CountColumns() / 2, " lightblue ", "White") would be used for each text box.
- B=iif(CountColumns() Mod 2, " lightblue ", "White") would be used for each text box
- C=iif(ColumnNumber(Nothing) / 2, " lightblue ", "White") would be used for each text box
- D=iif(ColumnNumber(Nothing) Mod 2, " lightblue ", "White") would be used for each text box.
Explanation
IIf(expr, truepart, falsepart) All three parameters are required: expr is the expression that is to be evaluated. truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr returns false. The MOD function can be used to divide numbers in Excel. Unlike regular division, however, the MOD function only gives you the remainder as an answer. The syntax for the MOD function is: = MOD ( Number , Divisor )
Community Discussion
No community discussion yet for this question.