文档介绍：CHAPTER1 1 Spreadsheet Basics
After studying this chapter, you should be able to:
1. Explain the basic purpose of a spreadsheet program.
2. Identify the ponents of the Excel screen.
3. Navigate the Excel worksheet (entering, correcting, and moving data
within the worksheet).
4. Explain the purpose and usage of Excel’s built-in functions and macro
functions.
5. Create graphics and know how to print and save files in Excel.
The term “spreadsheet” covers a wide variety of elements useful for quantitative
analysis of all kinds. Essentially, a spreadsheet is a simple tool consisting of a
matrix of cells that can store numbers, text, or formulas. The spreadsheet’s power
comes from its ability to recalculate results as you change the contents of other
cells. No longer does the user need to do these calculations by hand or on a
calculator. Instead, with a properly constructed spreadsheet, changing a single
number (say, a sales forecast) can result in literally thousands of automatic changes
in the model. The freedom and productivity enhancement provided by modern
spreadsheets presents an unparalleled opportunity for learning financial analysis.
1
1
2 Spreadsheet Basics
CHAPTER 1: Spreadsheet Basics
Spreadsheet Uses
Spreadsheets today contain built-in analytical capabilities previously unavailable in
a single package. Users often had to learn a variety of specialized software
packages to do any plex analysis. With the newest versions of
Microsoft Excel, users can perform tasks ranging from the routine maintenance of
financial statements to multivariate regression analysis to Monte Carlo simulations
of various hedging strategies.
It is literally impossible to enumerate all of the possible applications for
spreadsheets. You should keep in mind that spreadsheets are useful not only for
financial analysis, but for any type of quantitative analysis whether your specialty
is in marketing, management, engineering, stat