Question

Now you want to display a list of state abbreviations that occur only once within the cell M2, insert the UNIQUE function to display a list of state abbreviations that occur only once within the range H7:H34.

a) =UNIQUE(H7:H34)
b) =DISTINCT(H7:H34)
c) =SINGLE(H7:H34)
d) =SOLO(H7:H34)

Answer 1

The correct formula to display a list of state abbreviations that occur only once within the range H7:H34 in Excel is a) =UNIQUE(H7:H34). This function will list unique values from the specified range.

Step-by-step explanation:

To display a list of state abbreviations that occur only once within a range in Microsoft Excel, you can use the UNIQUE function. This function extracts unique values from a specified range. If you want to display a list of state abbreviations that occur only once within the range H7:H34 in cell M2, you would insert the following formula:

=UNIQUE(H7:H34)

The correct answer from the options provided is a) =UNIQUE(H7:H34). There isn't a DISTINCT, SINGLE, or SOLO function in Excel; UNIQUE is the function designed to return unique values from a data range.