SpreadsheetA spreadsheet is a document that stores data in cells within a table of columns and rows. Rows are usually labeled using numbers (1, 2, 3, etc.), while columns are labeled with letters (A, B, C, etc.). Cells are the individual boxes that lie between row and column, for example B1 and C5 would be individual cells. Every cell can store extraordinary information. By entering information into a spreadsheet, data can be stored in a more organized way than using plain content. The column/row structure also allows you to analyze information using equations and calculations. For example, each row of a spreadsheet can store information about a car that the Sutton dealership will sell. Each column can store a different aspect of car information, such as model, make, color, engine size, etc. Spreadsheet software can analyze this data by counting the number of people who bought a 2.0-liter car, listing all the people who bought white cars, or performing other calculations. This makes spreadsheets similar to databases. However, spreadsheets are more efficient than databases in terms of number crunching. This is why spreadsheets are commonly used in the scientific and financial industries. For example, a spreadsheet can store Sutton dealership sales data, including information on discounts, VAT, car price, etc. A column that stores the car prices of several cars can easily be added together to produce the total value of all cars purchased or by using the MIN and MAX formula you can also find the highest and lowest sales prices. Spreadsheets have now replaced paper-based diagrams all over the world. Although they were initially developed for accounting tasks, they are now… middle of the paper… and extensible. You can also create different graphs and charts for data generated from the spreadsheet or manually typed. Goal Seek and Scenarios Microsoft Excel has a feature called Goal Seek that lets you change the data used in a formula to find out what the results will be. The different results can then be compared to find out which one best suits your needs. Goal Seek is part of a suite of commands sometimes called what-if analysis tools. When the desired result of a single formula is available but not the input value needed by the formula to determine the result, you can do so by using the Goal Seek function available by clicking Goal Seek on the Tools menu. When searching for a goal, Microsoft Excel defers the value in a specific cell until a formula that depends on that cell returns the result.