A Consider the following MS-EXCEL spreadsheet:
| A | B | C | D | E | |
| 1 | Day | Weather | Temperature | Wind Speed | Average Temperature |
| 2 | Monday | Sunny | 30 | High | |
| 3 | Tuesday | Windy | 25 | Low | |
| 4 | Wednesday | Sunny | 32 | Medium | |
| 5 | Thursday | Windy | 23 | High | |
| 6 | Thursday | Sunny | 35 | Medium |
Suppose the formula - AVERAGEIFS(C2:C6, B2:B6, "Sunny", D2:D6, "Medium") is entered into E2, what is the value received in E2?
1
29
2
33.5
3
26
4
32