Consider the following MS-EXCEL spreadsheet:
| A | B | C | D | |
| 1 | Day | Mood | Energy | Go to Gym |
| 2 | Monday | Happy | High | |
| 3 | Tuesday | Sad | Low | |
| 4 | Wednesday | Neutral | Medium | |
| 5 | Thursday | Happy | Low | |
| 6 | Friday | Sad | Medium |
Suppose the formula - IF (B2 = "Happy", IF(C2 = "High" , "Yes" , "No"), "Yes") is entered into D2 and then the cell is copied and pasted to D3 : D6, On what days does Column D report "Yes"?
1
Only Thursday
2
Monday, Tuesday and Friday
3
Monday, Tuesday, Wednesday and Friday
4
Only Monday and Thursday