Question

You want to display an αbetical list of each state in cell L2. Insert a sort function with a nested unique function to display an αbetical list of state abbreviations in the range H7:H34.

a) =SORT(UNIQUE(H7:H34))
b) =αBETIZE(H7:H34)
c) =ORDER(UNIQUE(H7:H34))
d) =LISTSORT(H7:H34, "αbetical")

Answer 1

The correct formula to sort state abbreviations alphabetically in a spreadsheet is =SORT(UNIQUE(H7:H34)). The correct answer is a.

Step-by-step explanation:

The correct formula to display an alphabetical list of state abbreviations from the range H7:H34, eliminating duplicates, would be option (a): =SORT(UNIQUE(H7:H34)). This nests the UNIQUE function within SORT. The UNIQUE function removes duplicate entries, and the SORT function then orders the unique results in alphabetical order. This formula is used in spreadsheet software such as Sheets or Microsoft Excel.

Therefore the correct option is a.