tle 2

• 1978

  •Daniel “Dan” Bricklin & Robert “bob” Frankston


  -Created VisiCalc (Visible Calculator)

  -They created this calculator to solve analyse a spreadsheet for his report
• 1979

  Founded the company Software Arts

  They released the VisiCalc for the public

  Dan Bricklin was recognize as father of electronic spreadsheet

  The program runs only in apple II computer
• 1980

  •SuperCalc was released

  The first spreadsheet that ran on computer using CP/M operating system, was introduced
• 1981

  The Multiplan was released.

  The first spreadsheet to handle multiple spreadsheet simultaneously was released by Microsoft corp.
• 1983

  •Lotus 1-2-3 released was released, this program can handle 3 task (spreadsheet, graphs & Database)

  •Lisa Calc – the first spreadsheet program to use a mouse, by Apple computers.

  •Apple Works-  a primitive program that can handle three tasks (spreadsheet, databases and word processing) by Apple Computers
• 1985

  •Excel was released, the spreadsheet that can handle 3 tasks (spreadsheet, graphs, and data base) in a graphical environment, by Microsoft Corp.
• 1987

  Quattro Pro was released, another spreadsheet program that has a combine features of 1-2-3 and excel and runs in graphical environment, by Borland
• Uses of Spreadsheet

  •Designed to help you record, manipulate, analyse and present numerical information easily.

  •Business executives use spreadsheets in producing reports with charts and graphs

  •Teachers use spreadsheet to prepare reports of students’ grades.

  •Other profession use spreadsheet for their budget preparations, cash flows, financial reports, sales-and-cost analysis, stock inventories, strategic planning and sales presentations
• Features of Excel

  •Easy and quick saving, editing and retrieving of worksheets•Builds and edit formulas and enter functions

  •Does up to 12 different copy-paste actions at a time•Easy entry of range references in dialog boxes

  •Insert pictures/clip art to enhance work

  •Creates presentation-quality charts and graphs based on data entered

  •Enhanced formatting and layout features for creative reports
• 1. Electronic spreadsheet

  -It is simply an electronic or a computerized version of the accountant’s traditional paper spreadsheet.-Data are entered and calculated electronically, they can also be edited electronically and the results can be seen right away on the computer screen.
• 2. Spreadsheet program

  • It is an application program that helps the user to create spreadsheet commonly used for budgets, forecasting and other finance-related tasks.
• 3. Cell

  -This refers to the intersection of rows and columns
• 4. Work Book

  • The file within which you work and store your data
• 6. Active workbook window

  • This refers to the window that accepts entries and command.
• 7. Worksheet

  -This refers to the sheet of every workbook that contains lines and grids of columns and rows
• 8. Columns and Rows — Columns and Rows refer to how your cells are aligned. Columns are aligned vertically while rows are aligned horizontally.
• 9. Cell Reference — A cell reference is a set of coordinates that identifies a specific cell. It's a combination of letters and numbers. A5, for example, would point to the cell located where column A and row 5 intersect.
• 10. Cell Range — A Cell range is a collection of cells that have been identified as a group based on a variety of criteria. By using a colon (:) between cell references, Excel can determine the range, also known as an array
• 11. Operator — Operators are symbols or signs that indicate which calculation must be made in an expression. Operators do not necessarily refer to simple mathematical types; comparison, text concatenation or reference operators also exist.
• 12. Formula — A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign. This could be a mathematical equation, cell references, functions or operator. A formula is also known as an expression.
• 14. Freeze Panes — Freezing Panes allows you to select specific columns and/or rows to remain visible on the worksheet, even if you are scrolling, such as header cells that label a column.
• 13. Function — Functions are formulas that are pre-built into Excel. They are designed to help simplify potentially complex formulas in a worksheet.