Accounting – 5/29/19
I Bellwork Q & A
=A12*B12
- Describe and show what you would need to do to make A12 an absolute cell reference?
- 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