EX 140
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
The requirements document for the Modern Music Shops Six-Month Financial
Correctness
Studies have shown that
Projection worksheet is shown in Figure 3 –2. It includes the needs, source of data,
more than 25 percent of
summary of calculations, chart requirements, and other facts about its development.
all business worksheets
have errors. You can
ensure correctness in your
formulas by carefully
checking them using
Range Finder. The Formula
Auditing group on the
Formulas tab on the
Ribbon also can be helpful
when verifying formulas.
Figure 3 –2