Simnet excel project answers

USING MICROSOFT EXCEL 2016 Independent Project 7-6 Independent Project 7-6 The Hamilton Civic Center is developing a template with a calorie-tracking sheet for member exercise and a report about off-site seminars. You set data validation, complete formulas, and insert a combo box control. This project has been modified for use in SIMnet. Skills Covered in This Project • • • • Step 1: Download start file 1. • • • • Apply custom number format. Set data validation to use a list. Set data validation to use a date restriction. Create an error alert message. Add the Developer tab Insert a combo box control. Set properties for combo box control. Protect a worksheet. Open the HamiltonCC-07 workbook and click the Enable Editing button. The file will be renamed automatically to include your name. 2. Select cell D2 on the Data sheet and review the formula. The formula divides calories by time and rounds the results to three decimal places. Format Coils X 3. Select cells D2:D10 and open the Format Cells dialog box. 4. Select the Custom category on the Number tab. Choose 0.00 in the sample list and edit the Type box to show 0.000. The number of zeros indicates how many positions display after the decimal point (Figure 7-77). Click OK. 5. Select cell D2 and click the Format Painter button [Home tab, Clipboard group]. Click the Calorie Tracking tab and paint the format to cells E3:E33. Number Al ignment Font Protection Fill Bo rde r J;ategory. Sampl• General Number 5,889 Currency Accou nti ng Date !YP-= o.ootj Time Percentage General Fraction SdentWlc 0 0.00 "·"•o ..,... 0.00 Text Soedal L- #,*tiOJ;ltl,ff~ • .••OJ;[R•dJI","~ io, hO.OOJ;(il,ri0.00) io, hO.OOJ;[R•d](",U0,00) Sli;!onthi , functi on ~ ~ lei l°"I • [ii.:I - ---7~Calorie Tracking 7-78 VLOOKUPformula Excel 2016 Chapter 7 Working with Templates and Sharing Work Last Updated: 12/28/17 Page 1 Independent Project 7-6 USING MICROSOFT EXCEL 2016 10. On the Calorie Tracking sheet, delete the data in cells A3:D23. Doh V11 ri dotio n !_Settings J Input Mes sage 11. Select cells B3:B33 and set data validation to use a Date that is less than or equal to TODAY (Figure 7-79). Include a Stop error alert with a title of Check Date and a message of Date must be today or in the past. E2J 1gnore .!l_ lank En d dat e: I= t odoy Q Ap p ly th ese I 16. Click the Hospital Seminars tab and select cell D4. This cell has Center Across Selection alignment applied. I C Cycling ''" Protcd1on Prop crtil:5 jnput rangt: [sGS8:SG S11 4 High·inten.s· t t ll lt nlc lf8 5 Low impact Q1opdown lln K: 6 Running D :l-D_sha di n,;i : Cancel E D F I () _]Calori M S.ssto n N,it;mes and Fees X l 3 Elli ?tica l !l OK 7-79 Data validation for dates Fom1at 0bject 1 2 8 1-- Ir ,. changfs to all other cells with the same settings Qear All 14. Draw a combo box control to cover cell F8 and open its Format Control dialog box. Select cells G8:G11 for the Input range and cell F8 for the Cell link (Figure 7-80). A E1 [tess t han or eq ual to 13. Display the Developer tab on the Ribbon and click the Data worksheet tab. • Error Al ert V lllid~ti: ion critcri~ 12. Select cells A3:D33 and remove the Locked cell property. Select cell A3 to position the insertion point. 15.