224|EXCEL – Bonds, James Bonds

[Grace_Bennett]

Time to complete: 10 minutes
difficulty: easy
Solution:
Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Katelyn_Pittman]

Time To complete: 15 minutes
Difficulty:Easy

Challenge224_Bonds_James_Bonds.xlsx (55.2 KB)

[Caroline_Howard]

Time to complete: 30 min
Level: Beg- Intermediate

Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[Meadow_Mitchell]

Time to Complete: 10 min
Rating: Beginner
Fun application of excel tables, although I think doing it without a pivot table is almost easier.

Steven & Deborah: $199.84
Emily: $200.94
William: $100.56

[Joseph_Laws]

Time to complete: 20 min
Difficulty: Beginner
Solution:

Deborah and Steven Johnson: 199.84
Emily Johnson: 200.94
William Brown: 100.56

[Sophie_Dong]

Time to complete: 20 mins. It was beginner ish level.
Answers:
Deborah Johnson: 99.63
Steven Johnson: 100.22
Total: 199.85

Emily Johnson: 200.94
William Brown: 100.56

[Hazel_Bell]

Time to complete: 25 minutes
Level: intermediate
Solutions:
Steven and Deborah: 99.625 and 100.21875
Emily Johnson: 200.9375
William Brown: 100.5625

[Morgan_Woodland]

Time to Complete: 25 minutes
Rating: intermediate
And the solutions are

[Zen_Villondo]

Time: 25
Level: Beginner

D and S	$199.84
E.J.	$200.94
W.B.	$100.56

[Logan_Messenger]

Steven and Deborah Johnson, who are married, want to know what money will be free by 9-30-2040.	99.63, 100.22
Emily Johnson would like to know how much is freed up by 3-31-2065.	200.94
William Brown needs to know what he’ll have available by 12-31-2060.	100.56

[Austin_Birch]

Time to complete: 10 mins
Difficulty: Beginner
Solution:
Steven and Deborah: 199.85
Emily: 200.94
William: 100.56

[Rachel_Hale]

Time to Complete: 20 minutes
Difficulty: beginner-intermediate

[Aidan_Greenwade]

Emily Johnson: 200.94
Steven and Deborah Johnson: 198.84
William Brown: 100.56

[Seth_Davis]

[Autumn_Behling]

Time to complete: 15 min
Rating: beginner

Steven and Deborah: 199.84
Emily Johnson: 200.94
William Brown: 100.56

[Jake_Lewis]

Steven + Deborah Johnson $198.84
Emily Johnson $200.94
William Brown $100.56

[Jessica_Bertolio]

Time to Complete: 25 min
Rating: Beginner if you know Pivot Tables
Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Shiro_Contreras]

Time to complete: 15 min
Difficulty: Beginner

Solution:

Steven and Deborah Johnson | $199.84
Emily Johnson | $200.94
William Brown | $100.56

[Kaisei_Tokuzawa]

Time to Complete: 20min.
Difficulty: Begineer

Answer:
Steven and Deborah: 199.8
Emily Johnson: 200.94
William Brown: 100.56

[Seager_Bogden]

James_Bond_Solution.xlsx (43.8 KB)
Time: 10 minutes
Rating: Easy