A spreadsheet lists days with Weather and Temp: Monday Sunny High, Tuesday Windy High, Wednesday Raining Medium, Thursday Sunny Low, Friday Sunny Medium in rows 2 to 6. The formula IF(B2"Raining", IF(C2="High", "No", "Yes"), "No") is entered in E2 and copied to E3:E6. On which days does column E report 'Yes'? (The symbol means NOT EQUAL TO.)
AMonday and Friday only
BMonday and Tuesday
CThursday and Friday only ✓ Correct
DMonday, Thursday and Friday
Correct answer: (C) Thursday and Friday only
Explanation
The formula prints Yes only when the weather is not Raining and the temperature is not High.
Thursday is Sunny with Low temperature, meeting both conditions, which makes it show Yes.
Friday is Sunny with Medium temperature, also meeting both conditions, which makes it show Yes.
Monday and Tuesday are High temperature, so the inner test returns No despite not raining.
Wednesday is Raining, so the outer test returns No straight away.
The nested IF first checks the weather, then checks the temperature only when it is not raining.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →