Question

mr. ibanez has shared a spreadsheet with his students. the first column is blank. the second column contains names in random order in cells b3:b13. additional data is located in columns c and d. he asks the students to alphabetize the names in descending order while maintaining the correlating data. the students correctly highlight cell range b3:d13 and then: a sort by: row 3:13, z → a. b sort by: row 3:13, a → z. c sort by: column b, z → a. d sort by: column d, a → z.

Explanation:

The goal is to alphabetize names (in Column B) in descending order while keeping correlated data (Columns C and D) linked. Sorting by Column B (where names are) with Z→A (descending alphabetical order) achieves this. Other options target wrong rows/columns or order.

Answer:

C. sort by: Column B, Z → A.