Practice Activities

Complete the activities at the end of each of the 3 pages in this module.

1: Data Cleaning

• Open the spreadsheet : Sample Spreadsheet

• Try using the Google Tools>Cleanup Suggestions and Google Tools>Column Stats to start the cleanup process

• Follow the steps in the documentation above to clean the data and prepare it for reporting.

2. Spreadsheet Skills

• Open the practice spreadsheet and follow the instructions on each tab to complete the skill on that tab.

3. Formulas

• Open the practice spreadsheet and follow the instructions on each tab to complete the skill on that tab.