文档介绍：* If you liked the Ebook visit to support my Cat MEME.
* More than 500,000 Interesting Articles are waiting for you .
* The Ebook starts from the next page : Enjoy !
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 t