Microsoft Office Tutorials and References
In Depth Information
EX 164
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Correctness
Studies have shown that
more than 25 percent of
all business worksheets
have errors. If you are
not careful entering
data and formulas,
then your worksheet
is prone to 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.
The requirements document for the Campus Clothiers Semiannual Financial
Projection worksheet is shown in Figure 3–2. It includes the needs, source of data,
summary of calculations, chart requirements, and other facts about its development.
Excel’s Usefulness
Just a few short years
ago, a what-if question
of any complexity only
could be answered
using a large, expensive
computer programmed
by highly paid
computer professionals.
Generating a result
could take days. Excel
gives the noncomputer
professional the ability
to get complex
businessrelated questions
answered instantaneously
and economically.
Figure 3–2
Search JabSto ::




Custom Search