Mrs. Traino - Room 341

  1. Home
  2. First Day of Class Information
  3. BIM
  4. Graphic Design and Illustration
  5. PALS
  6. Teen Leadership
  7. Business Management (S2S)
  1. History of Computer
  2. History of the Internet
  3. Copyright
  4. Unit 1 - Introducing Word
  5. Lesson 2 - Using a Word Processor
  6. Lesson 3 - Formatting Documents
  7. Lesson 4 - Advanced Formatting Features
  8. First Semester Final
  9. Unit 2: Excel
    1. Chapter 5 - Introducing Excel -
    2. Chapter 6 - Functions and Data
    3. Chapter 7 - Creating Charts
    4. Chapter 8 - Advanced Speardsheet Techniques
      1. Chapter 8 Test
    5. Unit 2 - Applications and Projects for Excel
      1. Unit 2 Applications and Projects - Stock Market Project
  10. Bridges Assignments
  11. Unit 3 - Access
    1. Lesson 1 - Introducing Access
    2. Lesson 2 - Creating, Modifying, and Relating Tables
    3. Lesson 3 - Working With Datasheets and Queries
    4. Lesson 4 - Working with Forms, Reports, and Data Access Pages
  12. Unit 3 Assessment
  13. Unit 4 - Power Point
    1. Lesson 1 - Introducing PowerPoint
  14. Lesson 2 - Designing a Presentation
  15. Lesson 3 - Enhancing A Presentation
  16. Second Semester Final
Home > BIM > Unit 2: Excel > Chapter 8 - Advanced Speardsheet Techniques

Chapter 8 - Advanced Speardsheet Techniques

Objective: 

  •  Using dates and times in formulas
  • creating tables
  • applying data validation tools
  • creating PivotTables and PivotTable Reports
  • Using the CHOOSE and VLOOKUP functions
  • Naming a Cell Range
  • Freezing Cells
  • Creating Hyperlinks to a workbook location
  • Embedding and linking objects
  • Creating Marcos
  • Log

 

Assignments:

 

  1. Read in the text Chapter 8 starting on page 331
  2. Complete all practices
  3. Complete the following exercises:        
    • Florida Flights
    • Used Books
    • Warranties
  4.  
File Attachments:
  1. Student Instructions - Depreciation (Review/Quiz) Student Instructions - Depreciation (Review/Quiz)
Author: Esperanza Traino
Last modified: 4/23/2012 9:27 AM (EST)