MRS. POOL'S BEARCAT CLASSES
  • 2021-2022
    • Syllabus/Classroom Forms
    • Multimedia
    • Digital Production
    • 8th Grade Computer Apps >
      • You're Hired!
      • Photoshop >
        • Green Screen
        • Create your own Magazine Cover
        • Layer Basics
        • Selection Tools: Melon Head
      • Media/Technology Career Presentation
      • Travel Agent Project
      • Microsoft Comprehensive Project
      • Intro to Computers Notes
    • 7th Grade Computer Apps >
      • State Project
      • Spring MS Excel
      • Spring MS Word
      • Location/Destination PPT
      • MS Word Projects
      • MS Word Formatting
      • Intro to Computers Notes
  • Classroom Information
  • Extras: Royalty Free Music

Chapter 2: Recording Student Grades

In this chapter, you will use Excel to work with multiple worksheets created to record student grades. You will learn about managing and organizing worksheets to insert, delete, or even hide data and also make your data easier to find. You will also learn about using functions in your formulas and the difference between a relative and an absolute reference.

Learning Objectives

  • Rearrange data on a worksheet
  • Manage multiple worksheets
  • Use functions to perform calculations
  • Use relative and absolute cell references in formulas
  • Define names for cells and ranges

Chapter Documents

ex16-c02-ppt.pdf
File Size: 235 kb
File Type: pdf
Download File

e2-d1-grades.xlsx
File Size: 14 kb
File Type: xlsx
Download File

e2-d8-newgrades.xlsx
File Size: 16 kb
File Type: xlsx
Download File

e2-r1-volunteers.xlsx
File Size: 9 kb
File Type: xlsx
Download File

e2-r3-savings.xlsx
File Size: 11 kb
File Type: xlsx
Download File

e2-a1-prices.xlsx
File Size: 9 kb
File Type: xlsx
Download File

e2-a3-profit.xlsx
File Size: 9 kb
File Type: xlsx
Download File

e2-e1-repurchase.xlsx
File Size: 9 kb
File Type: xlsx
Download File

e2-e2-revenue.xlsx
File Size: 9 kb
File Type: xlsx
Download File

e2-e3-saucesales.xlsx
File Size: 9 kb
File Type: xlsx
Download File

Proudly powered by Weebly
  • 2021-2022
    • Syllabus/Classroom Forms
    • Multimedia
    • Digital Production
    • 8th Grade Computer Apps >
      • You're Hired!
      • Photoshop >
        • Green Screen
        • Create your own Magazine Cover
        • Layer Basics
        • Selection Tools: Melon Head
      • Media/Technology Career Presentation
      • Travel Agent Project
      • Microsoft Comprehensive Project
      • Intro to Computers Notes
    • 7th Grade Computer Apps >
      • State Project
      • Spring MS Excel
      • Spring MS Word
      • Location/Destination PPT
      • MS Word Projects
      • MS Word Formatting
      • Intro to Computers Notes
  • Classroom Information
  • Extras: Royalty Free Music