A Consider the following 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 |
Friday |
Sunny |
Medium |
Suppose the formula - IF (B2< > ''Raining", IF(C2 = "High" , "No" , "Yes"), "No") is entered into E2 and then the cell is copied and pasted to E3 : E6, On what days does Column E report "Yes"?
Note: (The symbol <> represents "NOT EQUAL TO").
1
Monday and Friday only
2
Monday and Tuesday
3
Thursday and Friday only
4
Monday, Thursday, and Friday