Day 57-58

Upon completion of Lesson 6, you will be able to:

  • Sort data in a worksheet.
  • Use AutoFilter to display only specified data in a worksheet.
  • Apply conditional formatting to highlight data.
  • Hide worksheet columns and rows.
  • Insert a shape in a worksheet.
  • Insert a picture in a worksheet.
  • Use a template to create a new workbook.
  • Insert a hyperlink in a worksheet.
  • Download a workbook in a different file format.
  • Insert, edit, and delete comments.

Lesson 6 Folder

  1. Create a new folder inside of your Google Spreadsheet folder and name it Lesson 6.
  2. Once your folder is created, you will need to locate the following shared files in this Lesson 6 folder:
    • City
    • Employee
    • Oil
    • Botany
    • Tax
    • Expense
    • Impact
    • School
    • Compact 
    • Paper
    • Rose
    • School Bus
  3. Make a copy of these files, move those copies into the Lesson 6 folder, and rename them without the Copy of so the Google Spreadsheet looks like the file names above. 

Lesson 6 Textbook

  1. Read the textbook and complete the step-by-step activities as they appear in your reading.