Reference no: EM132671604

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 D19.

Question 1: Enable users to select a store from the drop-down menu in B19.

Question 2: Set up a drop-down menu in C13 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.

Question 3: If you change the store in B19, then C19 might temporarily not list a candy bar sold at the newly selected store. Ensure that in C19, your worksheet reads Make selection above if this is the case. For example, if B19 contains CVS and C13 contains gumballs, then C19 should display Make selection above