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

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation