Consider the following in MS-EXCEL spreadsheet:
| A | B | C | D | E | |
| 1 | Day | Weather | Temp. | Play Tennis? | Go Running? |
| 2 | Monday | Sunny | High | ||
| 3 | Tuesday | Windy | High | ||
| 4 | Wednesday | Raining | Medium | ||
| 5 | Thursday | Sunny | Low | ||
| 6 | Frday | Sunny | 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"?
1
Monday and Friday only
2
Monday and Tuesday only
3
Thursday and Friday only
4
Monday, Thursday and Friday