Practice Activities

 

Lesson 5: Working Overtime

Before You Begin: Start Microsoft Excel 2010.

 

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