文档介绍：1CHAPTER 1 Spreadsheet BasicsThe term “spreadsheet” covers a wide variety of elements useful for quantitativeanalysis of all kinds. Essentially, a spreadsheet is a simple tool consisting of amatrix of cells that can store numbers, text, or formulas. The spreadsheet’s es from its ability to recalculate results as you change the contents of othercells. No longer does the user need to do these calculations by hand or on acalculator. Instead, with a properly constructed spreadsheet, changing a singlenumber (say, a sales forecast) can result in literally thousands of automatic changesin the model. The freedom and productivity enhancement provided by modernspreadsheets presents an unparalleled opportunity for learning financial studying this chapter, you should be able to:1. Explain the basic purpose of a spreadsheet . Identify the ponents of the Excel . Navigate the Excel worksheet (entering, correcting, and moving datawithin the worksheet).4. Explain the purpose and usage of Excel’s built-in functions and . Create graphics and know how to print and save files in 1CHAPTER 1: Spreadsheet Basics2Spreadsheet UsesSpreadsheets today contain built-in analytical capabilities previously unavailable ina single package. Users often had to learn a variety of specialized softwarepackages to do any plex analysis. With the newest versions ofMicrosoft Excel, users can perform tasks ranging from the routine maintenance offinancial statements to multivariate regression analysis to Monte Carlo simulationsof various hedging is literally impossible to enumerate all of the possible applications forspreadsheets. You should keep in mind that spreadsheets are useful not only forfinancial analysis, but for any type of quantitative analysis whether your specialtyis in marketing, management, engineering, statistics, or economics. For that matter,a spreadsheet can also prove valuable for personal uses. With Excel it is a fairlysi