Suppose you define 2 range names ‘CAR’ and ‘BIKE.  There are two possibilities to identify range names.

First option: Use Formulas tab, Data Manager, select Use in Formula, Paste Names (last item) [or short cut by pressing F3].

which brings the Paste Name dialog box:

Select the Paste List item. The list is now the selection.

Second option: What most people do not know is that when you zoom down from 39%, you can see the range names directly on your sheet.