Practice Activities

Module 3: Practice Activities

1. Conditional Formatting

• Open the practice worksheet and follow the instructions to practice conditional formatting.

2. Filtering:

• Open the practice worksheet and follow the instructions to practice conditional formatting.

3. Data Validation

• Open the practice worksheet and follow the instructions on the worksheet to practice data valildation.

4. VLOOKUP

• Open the practice worksheet and follow the instructions on the worksheet to practice vlookup.

5. Data Consolidation

• Open the Practice Worksheet and follow the instructions on each sheet to link data from one sheet to another.

6. Pivot Table Activity

• Video Directions: This activity was produced by Alice Keeler. Download the sample spreadsheet above and follow along with the video using this spreadsheet:

• Sample Spreadsheet

7. Telling Your Story: Sample Spreadsheet: Follow the directions on this sample spreadsheet to create charts, graphs, and sparklines.