Скачать или смотреть Excel 2021 In Practice - Ch 7 Independent Project 7-6 | In Practice Ch 7 Independent Project 7 6

Excel 2021 In Practice - Ch 7 Independent Project 7-6 | Excel 2021 In Practice Ch 7 Independent Project 7 6

#Excel_2021_In_Practice_Ch 7_Independent_Project_7-6 #In_Practice_Ch 7_Independent_Project_7-6 #Ch 7_Independent_Project_7-6


Contact Me:

WhatsApp : +92 3219349506
Email : [email protected]

Direct WhatsApp Link:
https://tinyurl.com/mr2fb6z5





Independent Project 7-6

Steps to complete This Project
Mark the steps as checked when you complete them.


Open the HamiltonCC-07 start file and click the Enable Editing button. The file will be renamed automatically to include your name.
Review and edit a spin button form control.


Right-click the spin button control on the Daily sheet.

Review the settings on the Control tab; note that the linked cell to the left of the control displays the results.

Click the Protection tab and deselect the Locked box.

Click the Alt Text tab and add the following: This is a spinner control to count clients..

Click OK.
Copy and edit form controls.


Confirm that the control is selected.

Copy it to the Clipboard and paste it.

Drag the copied control to cell C7.

Paste again and drag the second copy to cell C9.

Paste three times and position the controls as shown in Figure 7-86.
Copied spin button form controls
Figure 7-86 Copied spin button form controls


Select all six controls and align them on the right.

Right-click the control in cell C7 and change the Cell link to cell $B$7.

Edit the linked cell for each of the controls.

Delete any values that display in column B.
Insert a list box form control.


Display the Developer tab on the Ribbon if it is not shown.

Select cell E2 and unlock it. This will be the linked cell for the control.

Draw a list box control to cover cells E2:F2.

Format the control to use the list on the Data sheet and assign cell E2 as the linked cell.

Verify that the Selection type is Single.

Deselect the Locked property on the Protection tab. This unlocks the actual control.

Size the control to reach row 4 (Figure 7-87).
List box form control
Figure 7-87 List box form control


Select cell A3.
Unlock cells and protect a sheet.


Select cells B5, B7, B9, B11, B13, and B15 and unlock them.

Mark the logo on the Daily sheet as decorative.

Select cell B5 and protect the Daily sheet without a password.

Select Wednesday in the list box control.
Use the spin button controls to complete the counts in column B (Figure 7-88).

Excel 7-6 completed
Figure 7-88 Excel 7-6 completed


Use the spin button control in cell C5 to change the count for Block Party Permit to 2.

Use the spin button control in cell C7 to change the count for Building Permit to 3.

Use the spin button control in cell C9 to change the count for Overnight Parking Permit to 1.

Use the spin button control in cell C11 to change the count for Pay/Contest Parking Ticket to 4.

Use the spin button control in cell C13 to change the count for Vehicle Registration to 5.

Use the spin button control in cell C15 to change the count for Voter Registration to 7.

Hide the Developer tab.

Save and close the workbook.

Upload and save your project file.

Submit file for grading.