> > >

Excel MCQs

The logic for the formula in cell B2: =IF(A2>5,.2,0) is expressed as:

.2 in cell B2 if the value in cell A2 is greater than 5; otherwise return 0

0 in cell B2 if the value in cell A2 is greater than or equal to 5; otherwise return .2

.2 in cell B2 if the value in cell A2 is less than 5; otherwise return 0

Answer

Correct Answer: .2 in cell B2 if the value in cell A2 is greater than 5; otherwise return 0

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it