History-of-Microsoft-Excel-Discovery, Wh

The History of Ms Excel

1. History of Microsoft Excel

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

3. 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.

4. 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

5. 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

6. U ses 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

7. A P I M N I N T O U L A ONE WORD

8. 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

9. Excel Definition of Terms 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.

10. R H T E W E S O K ONE WORD

11. Excel Definition of Terms 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.

12. Excel Definition of Terms 3. Cell This refers to the intersection of rows and columns 4. Work Book - The file within which you work and store your data

13. S C I E N T E R T N I O ONE WORD

14. Excel Definition of Terms 5. Worksheet This refers to the sheet of every workbook that contains lines and grids of columns and rows 6. Active workbook window - This refers to the window that accepts entries and command.

15. Excel Definition of Terms 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.

16. U M O C N L ONE WORD

17. Excel Definition of Terms 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.

18. Excel Definition of Terms 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. A range in a row, for example, could look like A1:C1, telling the formula to look at the cells in a row between A1 and C1, while B4:D9 would tell the formula to look at all cells in a box bounded by columns B and D and rows 4 and 9. A 3-D reference refers to a range that encompasses more than one worksheet in the same workbook.

19. E L C T I O L O C N O F S C L E L THREE WORDS

20. Excel Definition of Terms 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.

21. Excel Definition of Terms 13. Function —  Functions are formulas that are pre-built into Excel. They are designed to help simplify potentially complex formulas in a worksheet. 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.

22. T A H M A C I M L A T E S P E Y T TWO WORDS

23. Parts of MS Excel sd Screen

24. Quick access toolbar

25. Title bar

26. Window control buttons

27. Menu tabs

28. ribbon

29. Scroll bar

30. View Buttons

31. Zoom Slider

32. Status Bar

33. Name Box

34. Name Box - It displays the name of the active cell - The name of the cell is composed of the column and row name

35. Formula Bar

36. Formula Bar - It is located below the ribbon - It displays the content of the active cell

37. Columns - This appears vertically and is identified by letters

38. Rows - This appears horizontally and is identified by numbers

39. Row Heading Column Heading

40. Active Cell - It is the currently selected cell with a darker box around it

41. Sheet Tab - Appears at the button of the screen

42. Grid Lines / spreadsheet area - It is composed of cells

43. Enumerate the different parts of the MS Excel window.

44. Chloe is a grade 7 ICT student. Their activity for next week is to identify the different parts of the MS Excel. How can you help Chloe to be prepared for next week’s lesson and activity?