Barry Creates a Table Showing Ranks and Percentage His Students

question 26

Multiple Choice

Barry creates a table showing ranks and percentage his students obtained in their final exams.He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9,the heading "Rank" in cell B3 and the height of students in cells B4 to B9,the heading "Percentage" in cell C3 and the weight of students in cells C4 to C9.One of the students,Cara's name,rank,and percentage are mentioned in cells A7,B7,and C7,respectively.He types Cara's rank in cell A14.What formula can he use in cell B14 to find the column in which Cara's rank is?

• A) =MATCH (A14,A3:C9,1)
• B) =MATCH (A14,A3:C3,0)
• C) =MATCH (B14,A3:C3,0)
• D) =MATCH (B14,A4:C9,1)

---

Definitions:

Online Shopping

The act of purchasing goods or services over the internet, involving the search, selection, and payment of products via electronic platforms.

Time Utility

The value added to products or services by making them available at a convenient time for consumers.

Nonstore Retailing

Retail operations that sell products to consumers through channels other than traditional brick-and-mortar stores, such as online shopping, catalog mail order, and direct selling.

Vending Machines

Automated machines that sell items such as snacks, beverages, and tickets to consumers after money, a credit card, or a specially designed card is inserted into the machine.