The file named Candybardata.xlsx contains a list of stores where you sell candy bars. The worksheet also contains the types of candy bars you sell at each store and the price charged for each candy bar. Set up your worksheet so that users can enter or select both the store and a candy bar from a drop$-$down menu and have the price show up in D$19.$

Enable users to select a store from the drop$-$down menu in B$19.$

Set up a drop$-$down menu in C$13$ to let users choose a type of candy bar from a list containing only those candy bars sold at a selected store. Hint: Use the INDIRECT function when defining the list.

If you change the store in B$19,$ then C$19$ might temporarily not list a candy bar sold at the newly selected store. Ensure that in C$19,$ your worksheet reads Make selection above if this is the case. For example, if B$19$ contains CVS and C$13$ contains gumballs, then C$19$ should display Make selection above. Here is the data set arranged like this. All solutions did not work. Please show the complete EXCEL commands from renaming the list. Thank you!