A small grocery owner creates a table for the different types of fruits sold in his shop. He inserts headings in cells A1, B1, C1, and D1 as Order ID, Fruit, Unit Price, and Quantity. He then inserts Order ID 1001 to 1004 for each fruit in cells A2 to A5, respectively, type of fruits—Apples, Oranges, Mangoes, and Grapes in cells B2 to B5, respectively, unit price of each fruit as $10, $9, $30, and $18 in cells C2 to C5, respectively, and quantity of each fruit as 5, 7, 8, and 9 in cells D2 to D5, respectively. In cell F1, he inserts the formula: =LOOKUP(1003, A1:A5, B1:B5). What will the following function return?
A) 8
B) $30
C) 1003
D) Mangoes

Question

A small grocery owner creates a table for the different types of fruits sold in his shop. He inserts headings in cells A1, B1, C1, and D1 as Order ID, Fruit, Unit Price, and Quantity. He then inserts Order ID 1001 to 1004 for each fruit in cells A2 to A5, respectively, type of fruits—Apples, Oranges, Mangoes, and Grapes in  cells B2 to B5, respectively, unit price of each fruit as $10, $9, $30, and $18 in cells C2 to C5, respectively, and quantity of each fruit as 5, 7, 8, and 9 in cells D2 to D5, respectively. In cell F1, he inserts the formula: =LOOKUP(1003, A1:A5, B1:B5). What will the following function return?
A) 8
B) $30
C) 1003
D) Mangoes

Quizplus · Accepted Answer

The LOOKUP function searches for the value 1003 in the range A1 to A5, and if found, returns the value in the same position in the range B1 to B5. In this case, 1003 is found in cell A3, which contains "Mangoes", so the function will return "Mangoes".

A Small Grocery Owner Creates a Table for the Different