Excel – Adding numbers exercise – Quick reference

File setup and submission

  • Open the workbook named 'Excel – adding numbers exercise' and save as 'Excel – adding numbers exercise – Completed'.
  • After finishing, re-save the file and use Submit assignment to upload the completed file.

Step-by-step formulas

  • B8: =B5+B6
  • C8: =C5+C6
  • D8: =D5+D6
  • F5: =B5+C5+D5
  • F6: =B6+C6+D6
  • B17: =SUM(B11:B15)
  • C17: =SUM(C11:C15)
  • D17: =SUM(D11:D15)
  • F11: =SUM(B11:D11)
  • F12: =SUM(B12:D12)
  • F13: =SUM(B13:D13)
  • F14: =SUM(B14:D14)
  • F15: =SUM(B15:D15)

Final steps

  • After completing, re-save the file and use Submit assignment to upload.

Page 2: Communication

  • If you have questions, email me. Remember that this is due by the “Due Date” listed on your Syllabus.