What output will the LOOKUP rmula below produce in relation to the following table?
LOOKUP(4.67,A1:A6,B1:B6)
2
AB
3.25
clear
3.91 cloudy
4.23 windy
4.67
rainy
5.12
snowy
5.98
sunny
A.
snowy
cloudy
C.
rainy
D. windy

Respuesta :

Answer:

The correct answer is (C)-Rainly

Explanation:

The following data is given in this question

Column A    Column B

3.25             Clear

3.91              Cloudy

4.23             Windy

4.67              Rainy

5.12               Snowy

5.98              Sunny

As we know that the Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array.

The use of lookup function is given below

LOOKUP(4.67,A1:A6,B1:B6)

When you execute this function on the given ranges , then it display "Rainly" as a result.

Furthermore, the complete example is attached with this solution

Ver imagen asarwar