ICT · Spreadsheets

Consider the following data in an MS-EXCEL spreadsheet: Cell A1=Day, B1=Weather, C1=Temp., D1=Play Tennis? Cell A2=Monday, B2=Sunny, C2=High Cell A3=Tuesday, B3=Windy, C3=High Cell A4=Wednesday, B4=Raining, C4=Medium Cell A5=Thursday, B5=Sunny, C5=Low Cell A6=Friday, B6=Sunny, C6=Medium Suppose the formula =IF(B2='Sunny', IF(C2 'Low', 'Yes', 'No'), 'No') is entered into D2 and then the cell is copied and pasted to D3:D6. On what days does Column D report 'Yes'?

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Correct answer

Monday and Friday only

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Spreadsheets?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in ICT · Spreadsheets

Which of the following territories was annexed by Lord Dalhousie under the pretext of misgovernance, and not directly through the Doctrine of Lapse?

What was the primary stated reason for the Partition of Bengal in 1905 by Lord Curzon?

Which of the following events is considered the immediate trigger for the launch of the Non-Cooperation Movement by Mahatma Gandhi?

Related Practice Questions