Mrs. Traino - Room 341

Home > BIM > Unit 2: Excel > Chapter 5 - Introducing Excel -

Chapter 5 - Introducing Excel -

Using A Spreadsheet

 

With Chapter 5, you will:

·         Modify and create cell styles

·         Insert and delete columns and rows to a worksheet

·         Use function and absolute cell reference in formulas

·         Sort data on a worksheet

·         Create an amortization table

·         Work with multiple sheets

·         Use the “What if” questions to help analyze data on a worksheet

·         Use the SLN function (EX 7)

 

The assignments listed below will give you practice with these TEKS as you create the desire effect for each worksheet

 

 

 Assignments:

 

1.       Complete all practices

2.       Complete the following exercises

o   Activity, Schedule – EX 1

o   Metric Conversions – Ex 4

o   Expenses, Expenses Analyzed – Ex 6

o   Personal Finances –Ex 7

o   Budget – Ex 10

3.       Review and Test on Chapter 5 on Friday

*Complete the assignments listed under "attachment". Due date for these assignments TBA (to be announced). 

 

 

 

File Attachments:
  1. College Budget College Budget
  2. Money 101 Money 101

Test Information

File Attachments:
  1. Chapter 5 Exam Chapter 5 Exam
  2. Review Review
Author: Esperanza Traino
Last modified: 4/23/2012 9:27 AM (EST)