Question

kara has selected the cell range a1:d8 in the worksheet shown. which option would allow kara to sort the data in alphabetical order according to the employees first names?
figure: a
a sort by: column a, a to z
b sort by: column c, z to a
c sort by: column b, z to a
d sort by: column b, a to z

Explanation:

To sort by employees' first names, we look at the column containing first names. In the table, first names are in Column B. Alphabetical order (A to Z) is the standard for ascending alphabetical sorting. Option D sorts Column B (first names) in A to Z order. Option A sorts Column A (IDs), B sorts Column C (cities) in reverse, C sorts Column B in reverse.

Answer:

D. Sort by: Column B, A to Z