Consider a spreadsheet in MS-Excel where column B holds the weather and column C holds the temperature: Monday is Sunny and High, Tuesday is Windy and High, Wednesday is Raining and Medium, Thursday is Sunny and Low, and Friday is Sunny and Medium. The formula IF(B2 equals Sunny, IF(C2 is not equal to Low, Yes, No), No) is entered into D2 and copied down to D3 through D6. On which days does column D report Yes?
AMonday and Friday only ✓ Correct
BMonday and Tuesday only
CThursday and Friday
DMonday, Thursday and Friday
Correct answer: (A) Monday and Friday only
Explanation
The formula returns Yes only when the day is Sunny and not Low, which happens on Monday and Friday.
Monday is Sunny with High temperature, so both tests pass and it shows Yes.
Tuesday is Windy, failing the Sunny test, so it shows No.
Wednesday is Raining, failing the Sunny test, so it shows No.
Thursday is Sunny but Low, failing the inner test, so it shows No.
Friday is Sunny with Medium temperature, so it shows Yes.
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 →