2 The title and column labels in the Week 1 worksheet are formatted with cell styles. You want to 3 apply this formatting. Group the Week 1, Week 2, Week 3, and Week 4 worksheets. Select the range A1:B1 on Week 1 and fill formats only across the other weekly worksheets. 3 Now you want to fill the formatting and contents to the other worksheets. 3 With the four weekly worksheets still grouped, select the range All:E11 and fill both content and formatting across the other weekly worksheets. You want to unlock the data-entry cells on the weekly worksheets. 2 With the worksheets still grouped, select the range A12:D40 and unlock the cells. 5 You want to create a data validation rule to control data entry. 8.89/10 Ungroup the weekly sheets, select the range D12:D40 in the Week 1 sheet, and then create a data validation rule with these specifications: . Allow Time greater than cell C12. . Enter the input message title: End Time. . Enter the input message: Enter the end time. (including the period). . Select the Stop error alert style. . Enter the error alert title: Incorrect End Time. . Enter the error message: The end time must be later than the start time. (including the period). Data Validation on 'D12:D40' in sheet Week 1 was not applied using "Start Time" set as "C12". 6 You want to duplicate the data validation rule on the other worksheets. 9 Select the range D12:D40 (if needed) and click Copy. Click the Week 2 sheet tab and group Week 2, Week 3, and Week 4 sheets. Select the range D12:D40, click the Paste arrow on the Home tab, select Paste Special, click Validation in the Paste Special dialog box, and then click OK. Ungroup the sheets. Note: Paste Special validation is not available on Excel for Mac. Excel for Mac users need to repeat Step 5 to create validations on the Week 2. Week 3. and Week 4 worksheets