Microsoft Excel 2007 - Beginning Tutorial 1 Inclass Development Steps 1. 2. 3. 4. 5. 6. 7. 8. 9. Copy Sample.xlsx from the I: drive. Start Excel from the Start Menu. Close Excel. Open your copy of Sample.docx Locate each item listed under A Tour of the Excel Screen in the Instructors Notes. Switch to the Chart sheet. Switch back to the Analysis sheet. Make F5 the active cell. Note the contents of the formula bar and the Name box. Change Diane’s last test score to 94. Note change in average.
10. Click the arrow next to background color. Note how Live Preview previews the results. 11. Click the dialog launcher in the Font group. Note Live Preview doesn’t function here. 12. Experiment hiding and restoring the Ribbon. 13. Switch between views. Return to Normal view. 14. Experiment with the Zoom controls and zooming using the mouse. 15. Practice moving around the worksheet and using shortcut keys. (Ctrl-Home, Home, Ctrl-End, arrows, Tab, Enter, Ctrl-PageUp/Down) 16. Practice scrolling using the arrows and scroll box. Note active cell doesn’t change. 17. Switch to the Chart sheet (only display one sheet at a time). 18. Rename Sheet 2 to Sample. 19. Delete the Sample sheet 20. Make the Chart sheet the first sheet 21. Insert a new sheet, Documentation, as the first sheet. 22. Change the background color of the Chart sheet 23. Practice selecting a range and then a collection of cells. 24. Close Sample 25. Open a blank Excel workbook. 26. Save the workbook as Final Exam Analysis.xlsx 27. Enter College Math Final Exam Analysis in A1. Enter student’s name in B1. 28. Click on A1. Note formula bar contents. 29. Undo 30. Enter all other labels in the appropriate cells. No formatting. 31. Add a second line to A1: Stevens Point Campus
32. In A20, enter the following values. Note formula bar contents after each one. Undo after each one. a. $1,000 b. 1,000 c. 1000 d. 27.5% 33. In A20, enter the following dates. Note formula bar contents after each one. Undo after each one. a. 8/20/2007 b. 8-20-07 c. 8/20 d. Aug 20, 2007 e. 12:00 f. 1:00 g. 7 p h. 7:15:45 p 34. Highlight B5 to D8. (Don’t enter Tina’s scores yet). 35. Enter scores and note what happens when press Enter. 36. Edit the semester, change the year. 37. Enter $15,000 in cell A20. 38. Delete the contents of A20. 39. Enter 1000 in A20 (still formatted). 40. Clear All in A20. 41. Enter 1000 in A20 (now unformatted) 42. Undo. 43. Enter the formula for E5: =B5 + C5 + D5 44. Using Point ‘n Shoot, enter the formula for F5: =B5 + C5 + D5 / 3 Note wrong answer 45. Edit formula to include parenthesis. 46. Note the difference in displayed cell contents and formula bar. 47. Delete the Total Points formula. 48. Use AutoSum to calculate Total Points 49. User AutoSum to calculate average, min and max for Test 1 (Note: adjustments needed) 50. Highlight the Test 3 scores. Note the statistics in the status bar. 51. Copy the Total Points and Average formulas at one time. Note the changes to the copied versions of the formulas. 52. Use the clipboard to copy the test statistics (B12:B14) to C12:D14 53. Enter test scores for Tina. Note Excel automatically updates statistics formulas and copies Total Points and Average formulas
54. AutoFit column E. 55. Manually size Column A 56. AutoFit row 1 (if adjusts to 3 lines instead of two, make column A a little wider and AutoFit row 1 again) 57. AutoFit columns B:D. Undo 58. Insert column for Test 4 59. Add label for Test 4 60. Insert columns for Test 5 and 6 61. Add score for first student. Note Total Points updates, but Average does not. 62. Copy score for first student (fill handle). Note formulas DON’T update. 63. Undo. Enter scores for Test 4 manually. 64. Update the Average formula to include Test 4 (don’t use AutoSum Average to keep order of precedence example). Update all other averages. 65. Add a row for the student. Enter scores. Copy formulas 66. Delete columns F&G. 67. Move the A3:G15 down a couple of rows. Note formulas update. 68. Undo. 69. Spell check the workbook. Insert a spelling error if necessary. 70. Change the orientation to Landscape. 71. Save the workbook using Save As. Point out and discuss, Save as 2003. 72. Review the Print process. 73. Search Help for align data (use Reposition the data) 74. Center the labels in B3:G4. 75. Right-align G1. Note overflows to the left. 76. Exit Excel, saving on the way out.