Management – 10/05/17
I. Bellwork Q & A
=A12*B12
- 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
- Format a What-If-Analysis to clearly identify assumption information pgs. 15-16
- Format a What-If-Analysis to protect Calculated Information pg 18-19
- Page 21 Budget for First Responder
- Pgs. 22-23 Creating a College Budget
Leave a Reply