Excel 2019 In Practice – Ch 7 Independent Project 7-6
The Hamilton Civic Center is developing a template for member exercise and off-site seminars. You create the template, set validation, enter formulas, and insert a combo box control. You then create a new workbook from the template.
Open the HamiltonCC-07 workbook and click the Enable Editing button. The file will be renamed automatically to include your name. 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. Select cells D2:D10 and open the Format Cells dialog
Create the template, set validation, enter formulas, and insert a combo box control. Select cell D2 on the Data sheet and review the formula.
