2, change the value 2. To reduce the chance of input error, Gwen wants you to make the Location column a dropdown list. Use data validation to create an in-cell dropdown list that restricts data in the Location column in the table (the range E4:E13) to the values Basie Hall, Cassatt Studio, Chopin Room. 3. Unhide the Students worksheet to prepare for working with student data. 4. Gwen added her name to the footer in each worksheet and now wants to remove it. Use the Document Inspector to remove only footer information from the workbook. (Hint: Do not save data when the dialog box appears.) [Mac Hint: The Document Inspector is not available on Excel for Mac, so manually remove all footers from the workbook.]