Copying, Moving and Formulas

 

Setting up the worksheet:

 

  1. Open up an Excel spreadsheet
  2. In cell A1, type in ‘Deo’s scores’ and in cell B2, type in ‘Score out of 100’
  3. Then, size the columns so that the data can fit in the cells – double click on the upper right hand boundary of column A, and then do the same for column B
  4. In cells A3 through A8, type in ‘Exam 1’, ‘Project 1’, ‘Exam 2’, ‘Project 2’, ‘Exam 3’, and ‘Project 3’, respectively
  5. Now, in cells B3 through B8, enter Deo’s scores – 98, 79, 85, 78, 69, and 95, respectively
  6. In cell A10, type in ‘Total Points’
  7. Click on cell B10, and enter the formula ‘=SUM(B3:B8)’
  8. Press ‘Enter’ on the keyboard, and watch as the formula changes to the number 504

 

Copying Cells:

 

  1. In cell D1, type in ‘Coco’s scores’
  2. Resize the column to fit the text by double clicking on the upper right hand boundary of column D
  3. Highlight cell B2
  4. Use the pull down menu and click on ‘Edit’ and then ‘Copy’
  5. Now click on cell E2
  6. Use the pull down menu again, and click on ‘Edit’ and then ‘Paste’
  7. Resize column E by double clicking on it’s upper right hand border
  8. Now highlight cells A3 through A10
  9. Right click with your mouse, and in the shortcut menu that appears, click on ‘Copy’
  10. Now click in cell D3
  11. Right click again with your mouse, and this time, in the shortcut menu that appears, click on ‘Paste’

 

Entering More Data:

 

  1. In cells E3 through E8, enter Coco’s scores – she received a 77 on the first exam, a 65 on her first project, a 99 on the second exam, an 82 on her second project, a 94 on the third exam, and an 89 on her third project

 

Copying Formulas:

 

  1. Highlight cell B10
  2. Use the pull down menu, and click on ‘Edit’ and then ‘Copy’
  3. Now, click on cell E10
  4. Use the pull down menu, and click on ‘Edit’ and then ‘Paste’ – note how the sum automatically appears

 

 

Your final worksheet should look like this: