MS Excel Formulas
1. 2. Open MS Excell Click on "File" in the Menu Bar Menu Bar Standard Toolbar Formatting Toolbar
Column Headings
Row Heading
Figure 1.1 3. 4. 5. 6. 7. 8. 9. 10. 11. Select "Save" Save to your "H Drive" Name the file "formulas" Click "OK" Click "View" in the Menu Bar Select "Header and Footer" Click "Custom Header" Click inside "Center Section" Type in the following: Last Name, First Name Period # Your Teacher's Name Date Click "OK" Click "OK" Excel gives headings to rows and columns Columns (up and down) are given letters (A, B, C…) Rows (across) are given numbers Thus, cells are located by coordinates: Letter & Number Type in the above NUMBERS from figure 1.1 starting with cell A3 and C3 Click "Save" Next, Select (highlight) cells A3-A17
12. 13. 14. 15. 16. 17. 18.
19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35.
25. 26. 27. 28. 29. 30. 31. 32. 33.
Click on "Edit" on the Menu Bar Select "Cut" Now click and select cell A2 Right click your mouse Select 'Paste" Click "Save" Now Select cells C3-C17 Find and click the "Cut" button on the Standard Toolbar Select cell B2 Find and click the "Paste" button on the Standard Toolbar Select the A3-B16 Change the Font to "Impact" Change font size to "12" Click on Help Select "Microsoft Excel Help" Type in the box "Add formulas" Formulas and functions you need to learn (make sure to label each column with the formula or function you are accomplishing): Auto Sum Column A Auto Sum Column B Add rows across (A2+B2, A3+B3, A4+B4, etc) Subtract Cell A2 from B2, A3 from B3, etc. Multiply cells across (same as above) Divide cells across (Divide smaller number from the larger number, i.e.: 24 divided by 3) Find the Average between the cells across Any other formula you would like Save your work We will all print together. Please wait for directions before moving on to #27! Click "File" in the Menu Bar Select "Print" Select "Pages" Type From "1" To "1" Click "OK" Exit Out Good Work