EXCEL

  • Start Excel.
    • Find Excel in your program menu and select it.
    • Once the program loads a screen should appears that looks like the one below.
Empty Spreadsheet

The first column in the spreadsheet is labeled A, and the first row is labeled 1. Spreadsheets use a coordinate system to access information. Each cell in the spreadsheet is identified by the letter-number combination of its location. Therefore you have cells names A1, B1, B2, B3, and so on.

Column&Row



Inserting Data

  • To insert data into excel select the cell in which you would like to enter the data. 
  • At this point you can enter the data in 1 of 2 spots
    • Primarily you will enter the data directly into the cell.
    • In some cased you will enter data into the formula bar.
Insert Data


At this point lets practice entering some data: Please make a  table as it is described below.

  1. Enter in cell A1 "Data"
  2. Enter in cell A2 "Car Number -"
  3. Enter in cell A3 "Track Number -"
  4. Enter in cell A4 "Mass (kg)="
  5. Enter in cell A6 "Trial"
  6. Enter in cell B6 "Distance (m)"
  7. Enter in cell C6 "Time (s)"
  8. Enter in cell D6 "Acceleration (m/s2)"
  9. Enter in cell E6 "Force (kg m/s2)"
  10. Enter in cell B2 "4"
  11. Enter in cell B3 "2"
  12. Enter in cell B4 "3"
  13. Enter in cell A7 "1"
  14. Enter in cell A8 "2"
Selected Cell
  • Select cells A7 and A8 by highlighting them.
  • Click on the small box in lower left hand corner of the selected cells and drag it down to 10. This is called Automatic Cell Filling
expanded data

  • Enter the following distances for trials 1-10
  1. 9.95
  2. 10.03
  3. 10
  4. 9.9
  5. 10.1
  6. 10.08
  7. 10.03
  8. 9.98
  9. 10.03
  10. 9.99
  • Enter 10 random times for trials 1-10 that are between 1.05 and 1.95 seconds.
  1. You chose a value between 1.05 and 1.95
  2. You chose a value between 1.05 and 1.95
  3. You chose a value between 1.05 and 1.95
  4. You chose a value between 1.05 and 1.95
  5. You chose a value between 1.05 and 1.95
  6. You chose a value between 1.05 and 1.95
  7. You chose a value between 1.05 and 1.95
  8. You chose a value between 1.05 and 1.95
  9. You chose a value between 1.05 and 1.95
  10. You chose a value between 1.05 and 1.95

  • Save your document naming it "LastName_Excel_Lab"