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: |

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

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

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

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

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

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

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

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

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