Question

Which range of cells represents the Lookup Table for finding which award each student received? Which lookup function would you use to fill C2:C7? What is your lookup value for student C?.

Answer 1

To find award of each student recieved we use VLOOKUP function.

What is VLOOKUP Function ?

VLOOKUP stated as 'Vertical Lookup' is a simplest functional form that makes excel to search a certain value in the column ie. Table Array in order to return values from different columns in that same row.

We use VLOOKUP when we need to find values in table or a range by given row.

Learn more about VLOOKUP here :https://brainly.com/question/14042837

Answer 2

Answer: First one is A (E7:F12)

              Second one is Vlookup

              Third one is 6

Explanation:

Just did the class in Alt Ed, sorry im late