Ch 7 Independent Project 7-6

Independent Project 7-6

The Hamilton Civic Center is developing a template for counting daily visits by purpose. You review an existing spin button and copy it to complete the form. You also insert a list box control.

[Student Learning Outcomes 7.1, 7.2, 7.4, 7.5, 7.6]

File Needed: HamiltonCC-07.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-HamiltonCC-07.xlsx

Skills Covered in This Project

• Copy a spin button control.
• Insert a list box control.
• Mark an image as decorative.
• Unlock cells for editing.
• Protect a worksheet.

Steps to complete This Project

Mark the steps as checked when you complete them.

1. Open the HamiltonCC-07 start file and click the Enable Editing button. The file will be renamed automatically to include your name.
2. Review and edit a spin button form control.
   1. Right-click the spin button control on the Daily sheet.
   2. Review the settings on the Control tab; note that the linked cell to the left of the control displays the results.
   3. Click the Protection tab and deselect the Locked box.
   4. Click the Alt Text tab and add the following: This is a spinner control to count clients..
   5. Click OK.
3. Copy and edit form controls.
   1. Confirm that the control is selected.
   2. Copy it to the Clipboard and paste it.
   3. Drag the copied control to cell C7.
   4. Paste again and drag the second copy to cell C9.
   5. Paste three times and position the controls as shown in Figure 7-86.Figure 7-86 Copied spin button form controls
   6. Select all six controls and align them on the right.
   7. Right-click the control in cell C7 and change the Cell link to cell $B$7.
   8. Edit the linked cell for each of the controls.
   9. Delete any values that display in column B.
4. Insert a list box form control.
   1. Display the Developer tab on the Ribbon if it is not shown.
   2. Select cell E2 and unlock it. This will be the linked cell for the control.
   3. Draw a list box control to cover cells E2:F2.
   4. Format the control to use the list on the Data sheet and assign cell E2 as the linked cell.
   5. Verify that the Selection type is Single.
   6. Deselect the Locked property on the Protection tab. This unlocks the actual control.
   7. Size the control to reach row 4 (Figure 7-87).Figure 7-87 List box form control
   8. Select cell A3.
5. Unlock cells and protect a sheet.
   1. Select cells B5, B7, B9, B11, B13, and B15 and unlock them.
   2. Mark the logo on the Daily sheet as decorative.
   3. Select cell B5 and protect the Daily sheet without a password.
6. Select Wednesday in the list box control.
7. Use the spin button controls to complete the counts in column B (Figure 7-88).Figure 7-88 Excel 7-6 completed
   1. Use the spin button control in cell C5 to change the count for Block Party Permit to 2.
   2. Use the spin button control in cell C7 to change the count for Building Permit to 3.
   3. Use the spin button control in cell C9 to change the count for Overnight Parking Permit to 1.
   4. Use the spin button control in cell C11 to change the count for Pay/Contest Parking Ticket to 4.
   5. Use the spin button control in cell C13 to change the count for Vehicle Registration to 5.
   6. Use the spin button control in cell C15 to change the count for Voter Registration to 7.
8. Hide the Developer tab.
9. Save and close the workbook.
10. Upload and save your project file.
11. Submit file for grading.