Warren creates a table listing the height and weight of students in his class.He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9,the heading "Height" in cell B3 and the height of students in cells B4 to B9,the heading "Weight" in cell C3 and the weight of students in cells C4 to C9.What formula can he use to look up the height of one of the students,Sari,whose name,height,and weight are mentioned in cells A7,B7,and C7,respectively?
A) =INDEX(A3:C9,4,2)
B) =INDEX(A7:C7,4,2)
C) =INDEX(A7:B7,2,4)
D) =INDEX(A3:B9,2,4)

Question

Quizplus · Accepted Answer

The correct formula to look up the height of Sari, given the described table layout, is =INDEX(A3:C9,4,2). This formula selects the range A3:C9, moves down 4 rows from the top of the range (to row 7, where Sari's data is), and then 2 columns to the right (to column B, where the heights are listed), to return Sari's height.

Warren Creates a Table Listing the Height and Weight of Students