Practice Activities

Lesson 5: Working Overtime Before You Begin: Start Microsoft Excel 2013.   Try This: Do the following steps 1. Open the MyName Timesheet that you created earlier in this lesson. 2. Go to the Timesheet and select Cell H13. In this example, it is the Cell that Sums the total hours worked. 3. Go to Home->Styles-> Conditional Formatting. 4. Select: Highlight Cell Rules-> Greater Than... 5. Format Cells that are Greater Than: 40     With: Green Fill and Dark Green Text 6. Click OK and test the formatting as follows: Enter sample data in the Time Sheet so that each day of the week, (Monday through Saturday has 8 hours. The Sum in Cell H13 should be 48, which is greater than 40. 7. Save this as YOUR NAME Working Overtime Practice.   Test Yourself 4. You can Autofill data validation a. True b. False Tip: Advanced Excel, page 181 5. Which Ribbon has the commands for Form Controls? a. Developer Ribbon b. Insert Ribbon c. Data Ribbon d. Review Tip: Advanced Excel, page 186 6. Which of the following is true about Combo Boxes? (Select all correct answers.) a. It’s a shape b. It has Drawing Tools available Tip: Advanced Excel, page 188 1. Data Validation alerts a user if the typed data does not match the set value. a. True b. False Tip: Advanced Excel, page 171 2. Which of the following are options for Data Validation? (Select all correct answers.) a. Settings b. Input Message c. Error Alert Tip: Advanced Excel, page 172 3. Which of the following are options for Data Validation error message options? (Select all correct answers.) a. Retry: leaves the error b. Cancel: clears the error c. Help: opens Excel’s help menu d. Ok: Accepts the error Tip: Advanced Excel, page 174