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 using letters (A, B, C, etc.). Cells are the individual box between the row and column, for example B1 and C5 would be individual cells. Each cell can store extraordinary information. By entering information into a spreadsheet, data can be arranged in a more organized manner than using simple content. The column/row structure also allows information to be analyzed using equations and calculations. For example, each row in a spreadsheet might 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 displacement, etc. Spreadsheet software can analyze this data by counting the number of people who bought a car with a 2.0 liter engine, listing all the people who bought white cars, or made other calculations . This makes spreadsheets similar to databases. However, spreadsheets are more efficient than databases in terms of crunching numbers. This is the reason why spreadsheets are commonly used in the scientific and financial industries. For example, a spreadsheet can store sales data from the Suttons dealership, including information on discounts, VAT, car price, etc. A column that stores the prices of multiple cars can easily be added together to produce the total value of all cars purchased or by using the MIN and MAX formulas to also find the highest and lowest sales prices. Spreadsheets have now replaced paper-based systems all over the world. Although they were originally developed for accounting tasks, they are now... middle of paper ......t and expandable. You can also create different charts and tables for data generated by a spreadsheet or entered manually. Goal Lookup and Scenarios Microsoft Excel has a feature called goal lookup that lets you change the data used in a formula to see the results. will be. The different results can then be compared to determine which one best suits your needs. Goal Seek is part of a suite of commands sometimes called simulation analysis tools. When the desired result of a single formula is available but not the input value that the formula needs to determine the result, this can be done using the Goal Finder feature available by clicking Goal Finder in 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.