Select cell C$10$ and enter a data validation rule to look up the department name from the cell range named Departments on the Options worksheet. Enter the Input Message title Department Enter the input message Select a department from the list. Enter an Error Alert title Error Enter the error message Invalid department. In cell C$10,$ select Front Desk.

I need help on these homework questions. It's not giving me the right input.

On the OrderForm worksheet, select cell range C$13$:C$18,$ and enter a data validation rule to look up the top options from the cell range named TopOptions on the Options worksheet. Leave the input message and error message blank.

Select cell C$13,$ and select Vest.

On the OrderForm worksheet, select cell range C$19$:C$24,$ and enter a data validation rule to look up the bottom options from the cell range named BottomOptions. Leave the input message and error message blank.

On the OrderForm worksheet, select cell range C$25$:C$30,$ and enter a data validation rule to look up the other options from the cell range named OtherOptions. Leave the input message and error message blank.

On the OrderForm worksheet, select cell range D$13$:D$30,$ and enter a data validation rule to look up the size options from the cell range named Sizes. The input message and error message can be left blank. Select cell D$13,$ and select Large. Select cell E$13,$ and type $2$

Select cell A$13$ and insert a hyperlink to the defined name Tops. Add a ScreenTip Go to Top Options Select cell A$19$ and insert a hyperlink to the defined name Bottoms. Add a ScreenTip Go to Bottom Options Select cell A$25$ and insert a hyperlink to the defined name Other. Add a ScreenTip Go to Other Options

If necessary, add the Developer tab to the ribbon. Record a macro named ClearForm with the shortcut key F in This Workbook. Add the description To clear the form for another order. Clear cell range C$6$:C$7,$ cell C$10,$ cell range C$13$:E$30,$ and cell C$33.$ Select cell C$6$ as the last step in your macro, and stop the recording. Undo the changes you made while recording the macro.

Insert a macro button in cell range F$6$:G$7$ to run the ClearForm macro. Change the button text to Clear Form Test the macro button.

In cell C$6,$ enter the name Kyle Humphrey In cell C$7,$ enter today$$s date In cell C$10,$ select Front Desk. In cell C$13,$ select Vest. In cell D$13,$ select Large. In E$13,$ type $2$