MRS. POOL'S BEARCAT CLASSES
  • 2022-2023
    • Syllabus/Signature Page
    • Photography I >
      • Spring 2023 Final Projects!
      • MARCH 15 23_Photo Blend 1
      • Color Pop
      • A-Z beginning scavenger hunt
      • Famous Photographers
      • Website Critique
    • 8th Grade Computer Apps >
      • Self Portrait
      • GreenScreen Combo Project
      • Painting Coyote
      • Create your own magazine cover
      • Layer Basics
      • Selection Tools: Melon Head
    • 7th Grade Computer Apps
    • Intro to Arts/AV >
      • Apple/Hills
      • Animate
    • Photography II
  • 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
  • 2022-2023
    • Syllabus/Signature Page
    • Photography I >
      • Spring 2023 Final Projects!
      • MARCH 15 23_Photo Blend 1
      • Color Pop
      • A-Z beginning scavenger hunt
      • Famous Photographers
      • Website Critique
    • 8th Grade Computer Apps >
      • Self Portrait
      • GreenScreen Combo Project
      • Painting Coyote
      • Create your own magazine cover
      • Layer Basics
      • Selection Tools: Melon Head
    • 7th Grade Computer Apps
    • Intro to Arts/AV >
      • Apple/Hills
      • Animate
    • Photography II
  • Classroom Information
  • Extras: Royalty Free Music