Spreadsheets and Business Graphics: Facts and Figures Chapter 13 Objectives Describe the advantages of spreadsheets List several applications for spreadsheets Explain the underlying principles of electronic spreadsheet use Describe how to set up and modify a spreadsheet
“What If” Analysis
The process of changing one or more spreadsheet values and observing the resulting calculated effect
What if we reduce the price by 5%?
What if we buy a home and the mortgage rate increases by .5%?
View and analyze data
Make a positive impression during a presentation
Help users analyze and understand data
Shows trends or cycles over time
Relationship between parts and whole
One wedge pulled slightly away from the pie