Excel – Part One IS 240

1. Excel – Part One IS 240

2. Competencies • Load Excel for Windows 95. • Use toolbars. • Move around the worksheet. • Design a worksheet. • Enter data. • Delete and edit cell entries. • Open and close workbooks. • Copy data. • Enter formulas.

3. Competencies • Recalculate a worksheet. • Change cell alignment. • Document, save and print a workbook. • Exit the Excel program.

4. Definition of Electronic Spreadsheets • Automated version of accountant’s ledger • Composed of rows and columns or primarily numeric data • Formulas based on cell references, so easy to update results • Easy to store, retrieve and print results

5. Alignment data’s position to the left, centered or right of a cell Electronic Spreadsheet Terminology

6. Alignment Cell - Columns vertical blocks of cells identified by letter data’s position to the left, centered or right of a cell space created by intersection of horizontal row and vertical column Electronic Spreadsheet Terminology

7. Copy duplicates contents of cell or cell to another location Electronic Spreadsheet Terminology

8. Copy File linking duplicates contents of cell or cell to another location creates a connection between two files to share data Electronic Spreadsheet Terminology

9. Format cell styles that control the appearance of the data there Electronic Spreadsheet Terminology

10. Format Formula cell styles that control the appearance of the data there entry performing a calculation Electronic Spreadsheet Terminology

11. Format Formula Function cell styles that control the appearance of the data there entry performing a calculation built-in formula Electronic Spreadsheet Terminology

12. Format Formula Function Graph cell styles that control the appearance of the data there entry performing a calculation built-in formula visual representation of data ranges in a worksheet Electronic Spreadsheet Terminology

13. Label entry consisting of text and numeric characters Electronic Spreadsheet Terminology

14. Label Move entry consisting of text and numeric characters relocates cell contents to another worksheet location Electronic Spreadsheet Terminology

15. Label Move Rows entry consisting of text and numeric characters relocates cell contents to another worksheet location horizontal blocks of cells identified by number Electronic Spreadsheet Terminology

16. Value numerical entry, or one resulting from a formula or function Electronic Spreadsheet Terminology

17. Value What-if Analysis numerical entry, or one resulting from a formula or function process of evaluating effects of changing one or more values in formulas to help in decision making and planning Electronic Spreadsheet Terminology

18. move handle Minimize, Restore/Maximum Close buttons menu bar Standard tool bar formula bar Formatting tool bar drawing tool bar Status bar work area Office Assistant

19. Using Office Assistant Office Assistant

20. Office Assistant

21. Arrow keys Moves cell selector one cell in direction of arrow Moving Around the Worksheet

22. Arrow keys Alt + Pg Dn Moves cell selector one cell in direction of arrow Moves cell selector right one full window Moving Around the Worksheet

23. Arrow keys Alt + Pg Dn Alt + Pg Up Moves cell selector one cell in direction of arrow Moves cell selector right one full window Moves cell selector left one full window Moving Around the Worksheet

24. Pg Dn Moves cell selector down one full window Moving Around the Worksheet

25. Pg Dn Pg Up Moves cell selector down one full window Moves cell selector up one full window Moving Around the Worksheet

26. Pg Dn Pg Up Ctrl + Home Moves cell selector down one full window Moves cell selector up one full window Moves cell selector to cell in upper-left corner of worksheet Moving Around the Worksheet

27. Home Moves cell selector to beginning of row Moving Around the Worksheet

28. Home Pg Up Moves cell selector to beginning of row Moves cell selector to last used cell in row Moving Around the Worksheet

29. Home Pg Up Ctrl + Home Moves cell selector to beginning of row Moves cell selector to last used cell in row Moves cell selector to last used cell in column Moving Around the Worksheet

30. Design a Worksheet • Specify purpose - ID the input data required, and the desired output • Design and build - either on paper or in Excel, should include title, row label and column headings, and some sample data

31. Types of Data Entries • Text - any combination of letters, numbers, spaces, etc • Number - the digits 0 thru 9, plus any of the special characters such as +, _, /, $, %, etc. • Formula - perform calculations on data contained in other cells

32. Entering Data • Move the cell pointer to the desired location in spreadsheet work area • Press the appropriate keys • Press the Enter key

33. Enter button Cancel button formula bar displays entry active cell displays entry and insertion point

34. text entries are left-aligned in cell space cell selector moves down to next cell after Enter is pressed

35. Delete and Edit Cell Entries • While still typing and before pressing enter • Escape, or Backspace • To delete an entry, press the Delete key • To edit a cell entry, press the F2 key, or double click

36. Home Moves insertion point to beginning of entry Key Strokes in Edit Mode

37. Home End Moves insertion point to beginning of entry Moves insertion point to end of entry Key Strokes in Edit Mode

38. Home End -> Moves insertion point to beginning of entry Moves insertion point to end of entry Moves insertion point one character right Key Strokes in Edit Mode

39. Home End -> <- Moves insertion point to beginning of entry Moves insertion point to end of entry Moves insertion point one character right Moves insertion point one character left Key Strokes in Edit Mode

40. Open and Close Workbooks • Open Workbook • File, Open • File Name • Close Workbook • File, Close

41. Delete and edit cell entries • Highlight cell • Delete key • Edit, Cut • Highlight cell • F2 key • Double mouse click

42. Cutting, Copying and Pasting Data • Cut - cell contents deleted from the cell location, but stored in the Clipboard • Copy - copy of cell contents stored in the Clipboard • Paste - contents of the Clipboard transferred to the destination cell location

43. Cut from source cell

44. Paste in destination cell

45. Copy from source cell

46. Paste in destination cell

47. Enter Formulas • Entries that perform calculations • Result of the calculation is displayed in the cell containing the formula • Always begins with an = sign, which tells Excel that a numeric operation follows

48. Enter Formulas • With multi operator formulas the order of precedence is • Exponents • Multiplication • Division • Addition • Subtraction

49. Enter Formulas • Operands - the values or cell references that the numeric operators operate on

50. + for addition Numeric Operators