80 likes | 157 Views
Hurricane Katrina. Help the children!. Helping the children. Build a model of a playhouse Find the cost of the models: Katrina.xls Compare the costs of the models A donor has been identified!!!!. A Cape Code Model. What are the building features for this house? Trimming Dutch door
E N D
Hurricane Katrina Help the children!
Helping the children • Build a model of a playhouse • Find the cost of the models: Katrina.xls • Compare the costs of the models • A donor has been identified!!!!
A Cape Code Model • What are the building features for this house? • Trimming • Dutch door • Shutters
A Victorian Model • What are the features of this house? • Child dutch door • Flowerboxes • Trimming
Your turn to work on the problem How much do these playhouses cost to build?
Spreadsheet Fundamentals • Avoid numeric values in formulas • Refer to values by cell referencing • Use built in formulas • Be careful with cell referencing (absolute vs. relative) • =sum(B2:B10)/8 • =sum(B2:B10)/B1 • =average(B2:B10) • = $B$3*B5 + $C$3