Accounting – 5/29/19

I Bellwork  Q & A

      =A12*B12

  1. Describe and show what you would need to do to make A12 an absolute cell reference?
  2. What is the purpose of creating an absolute cell reference?

II Objectives

  • Build formulas to create an accurate and flexible budget in Excel
  • Use relative versus absolute cell addresses to support What-If Analysis in Excel
  • Format a range of cells in Excel using the Format Painter
  • Format a budget in Excel to protect calculated information

III.  Notebook/Discussion

  • Thinking Map: Difference between absolute and relative cell references

IV Classwork:  Files on iLearn

  • Page 21 Budget for First Responder
  • Pgs.  22-23 Creating a College Budget

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.