10 1.2 11 1.2 If necessary, add the Developer tab to the ribbon. Create an absolute macro on the TicketOrder worksheet that will clear the contents of all cells containing data entered by the user. This includes the cell ranges B4:B6, B10:B15, and B18:B19. Select all three ranges before clearing the contents. Make cell B4 the active cell after the macro is run. Name the macro ClearData and assign the letter d as the shortcut key. After creating the macro, click the Undo button to undo the change you made. Add a form control button and assign the ClearData macro to the button. Change the button captions to Clear Data. Test the button. On the Developer tab, in the Code group, click Macros, and then click Edit. Copy the macro code and close the Microsoft Visual Basic for Applications window. Click the Macro worksheet and paste the copied macro code in cell A1 (there should be 11 lines altogether). On the TicketOrder worksheet, unlock cells A17, B4:B6, B10:B15, and B18:B19. From the Format Cells dialog box, hide all cells that have formulas: B7, B20, and B21. Hide the horizontal and vertical scroll bars. Note, Mac users can skip hiding the scroll bars. Hide the row and column headers. Hide the gridlines. Protect the worksheet. Save the workbook as a macro-free workbook. Mark the workbook as final. 12 1.6 13 1.2 14 1.2 15 1.2 16 0 17 0 Close the Excel_CHO_Assessment_Ticket.xlsx workbook. Exit Excel. Submit your file as directed. Total Points 20 10 1.2 11 1.2 If necessary, add the Developer tab to the ribbon. Create an absolute macro on the TicketOrder worksheet that will clear the contents of all cells containing data entered by the user. This includes the cell ranges B4:B6, B10:B15, and B18:B19. Select all three ranges before clearing the contents. Make cell B4 the active cell after the macro is run. Name the macro ClearData and assign the letter d as the shortcut key. After creating the macro, click the Undo button to undo the change you made. Add a form control button and assign the ClearData macro to the button. Change the button captions to Clear Data. Test the button. On the Developer tab, in the Code group, click Macros, and then click Edit. Copy the macro code and close the Microsoft Visual Basic for Applications window. Click the Macro worksheet and paste the copied macro code in cell A1 (there should be 11 lines altogether). On the TicketOrder worksheet, unlock cells A17, B4:B6, B10:B15, and B18:B19. From the Format Cells dialog box, hide all cells that have formulas: B7, B20, and B21. Hide the horizontal and vertical scroll bars. Note, Mac users can skip hiding the scroll bars. Hide the row and column headers. Hide the gridlines. Protect the worksheet. Save the workbook as a macro-free workbook. Mark the workbook as final. 12 1.6 13 1.2 14 1.2 15 1.2 16 0 17 0 Close the Excel_CHO_Assessment_Ticket.xlsx workbook. Exit Excel. Submit your file as directed. Total Points 20