Скачать или смотреть Shelly Cashman Excel 2016 | Module 11: SAM Project 1b

24 / 7 Live Support
[email protected]
website link: www.studyhelpme.com
WhatsApp: +44-7309655268
+91-9828671065

PROJECT STEPS
1.Brittany Keele works part-time at Heirloom Woodworking, a custom woodworking shop in Irving, Texas. She is completing an Excel workbook that one of the carpenters started but has not had time to finish. Switch to the Repair Quotes worksheet. Go to cell D5 and add the following
comment: Cabinetry can also be restored and rebuilt. (including the period) to the cell. Remove any other text that appears in the comment, including (if necessary) your name.
2.Use WordArt to add a watermark to the Repair Quotes worksheet as follows:
a. Use the Fill -Black, Text 1, Shadow option for the watermark. (Hint:Depending on your version of Office, the WordArt option may appear as Fill: Black, Text color 1; Shadow.)
b. Enter the text Draft for Review into the WordArt.
c.Reposition and resize the WordArt so that the upper-left corner is located in cell A6 and the lower-right corner is located in cell D10.
d.Set the transparency of the WordArt text to 90%.
3.Go to the Service Information worksheet. Add a background image to the worksheet, using the support file Support_SC_EX16_11b_Wood.jpg.
4.Brittany wants to make sure that no unauthorized edits can be made to this worksheet.
Protect the Service Information worksheet with the default settings, using Kee! eas the password.
5.The workbook includes a customer entry sheet, but several steps were left unfinished.
Go to the Customer Entry worksheet. Select the option button labeled Option Button 22
and then use the text Design to replace the placeholder text.
6. Add an Option Button (Form Control) to cell F8, using Final Figure 3 as a guide. Update the Option Button form control as identified below:
a. Use the text Scheduling to replace the placeholder text.
b.Confirm that the option button has a cell link to cell $J$26.
c.If necessary, resize and reposition the check box control so that the control text is completely visible and the check box control is located within cell F8.
7.Select the five option buttons in the range B9:E11. Align the option buttons using Align Top
formatting, distribute the buttons using the Distribute Horizontally option, and then reposition them within the range B10:E10.
8.Add a Group Box (Form Control) in the range A9:E11 that completely encloses the five option buttons in the range B10:E10. Make sure that the Group Box form control completely encloses the five option buttons’ text fields, which may be wider than the text displayed for each button.
9.Add a Check Box (Form Control) to cell C14, using Final Figure 3 as a guide. Update the Check Box form control as identified below:
a. Use the text Custom to replace the placeholder text.
b. If necessary, resize and reposition the check box form control so that the control text is completely visible and the check box form control is located within cell C14.
c. Format the Check Box form control so that it has a cell link to cell $N$25
.
10. In cell C15, format the Check Box form control with the label Repair so that it has a cell link to cell $Q$25. Use Paneling to replace the Repair label.
11.In cell J25, create a formula using the INDEX function to return the value from the named range Request_Type (which represents the range A29:A31) based on the value in cell J26
.
12.Now that the workbook is almost complete, Brittany wants to test it by adding a record to the mailing list.
a.Use the button labeled “Enter Customer Information” to enter the information shown in bold in Table 1 below: Table 1: