Excel – Adding Numbers exercise

supper simple assignment

Excel – Adding Numbers exercise

Open the Excel workbook file named: “Excel – adding numbers exercise” and immediately save this file
as “Excel – adding numbers exercise – Completed”.

see the attachments for details

Portland Recreation
Bike Path Construction Costs
Area 1
Cornish Forest
Haack Center
Brush Clearing
5883
6234
Paving
15580
18916
Landscaping
3271
1697
4981
4209
2000
1500
1000
17169
14062
1500
1200
800
1805
2437
1700
1300
1100
Total
Area 2
Hamilton Hills Park
Hansen Hills
McKinley Park
South Shore Beach
Cave Point
Total
Total Cost
Adding numbers exercise instructions (worth 10 points):
Open the Excel workbook file named: “Excel – adding numbers exercise” and immediately save this file
as “Excel – adding numbers exercise – Completed”.
1. In cell B8 enter the formula to add cells B5 and B6: You must use the =cell location + cell
location formula. For example =c1+c2 (obviously these are not the correct cells for the correct
formula in this case)
2. In cell C8 enter the formula to add cells C5 and C6: You must use the =cell location + cell
location formula. For example =c1+c2 (obviously these are not the correct cells for the correct
formula in this case)
3. In cell D8 enter the formula to add cells D5 and D6: You must use the =cell location + cell
location formula. For example =c1+c2 (obviously these are not the correct cells for the correct
formula in this case)
4. In cell F5 enter the formula to add cells B5 through D5 using the =cell location + cell location +
cell location formula.
5. In cell F6 enter the formula to add cells B6 through D6 using the =cell location + cell location +
cell location formula.
6. In cell B17 enter the formula to add cells B11 through B15: You must use the =sum(cell
location:cell location) formula. For example =sum(g1:g7) obviously these are not the correct
cells for the correct formula in this case
7. In cell C18 enter the formula to add cells C11 through C15: You must use the =sum(cell
location:cell location) formula. For example =sum(g1:g7) obviously these are not the correct
cells for the correct formula in this case
8. In cell D18 enter the formula to add cells D11 through D15: You must use the “=sum(cell
location:cell location) formula. For example =sum(g1:g7) obviously these are not the correct
cells for the correct formula in this case)
9. In cell F11 enter the formula to add cells B11 thru D11: You must use the =sum(cell location:cell
location) formula. For example =sum(g1:h1) obviously these are not the correct cells for the
correct formula in this case)
10. In cell F12 enter the formula to add cells B12 thru D12: You must use the =sum(cell location:cell
location) formula. For example =sum(g1:h1) obviously these are not the correct cells for the
correct formula in this case)
11. In cell F13 enter the formula to add cells B13 thru D13: You must use the =sum(cell location:cell
location) formula. For example =sum(g1:h1) obviously these are not the correct cells for the
correct formula in this case)
12. In cell F14 enter the formula to add cells B14 thru D14: You must use the =sum(cell location:cell
location) formula. For example =sum(g1:h1) obviously these are not the correct cells for the
correct formula in this case)
13. In cell F15 enter the formula to add cells B15 thru D15: You must use the =sum(cell location:cell
location) formula. For example =sum(g1:h1) obviously these are not the correct cells for the
correct formula in this case)
Once you have finished the above steps, re-save this file and use the “submit assignment” to upload
your completed file.
If you have any questions, email me.
Remember that this is due by the “Due Date” listed on your Syllabus.