Change the name of the "product" worksheet to $"$q$4".$ Position the worksheet sequentially in your workbook.

In the space allocated above the dataset, enter formulas using the MATCH and INDEX functions along with named ranges. These formulas should display the sales of a specified product for a given location. Include data validation to limit the selection of the product and location to those specified in the dataset. For instance, if the user opts for the product "Porter" and the location $"$MB$,"$ the formula result should reveal $$96,796.$ If no product or location is chosen, the result should not display #N$/$A$.$

Include descriptive statistics $($using Excel's analysis tool$)$ analyzing the $"$BC$"$ values. Set the location of these statistics to begin in Q$4.$

There may be multiple modes in the sales values $($C$12$:O$27).$ Starting in $F5,$ use the appropriate function to display these modes.