224|EXCEL – Bonds, James Bonds

[Emmanuel_Mills_Obboh]

Time to complete: 26 mins.
Answers:
Deborah and Johnson: 198.84

Emily Johnson: 200.94

William Brown: 100.56

[Liam_Smith]

Steven and Deborah Johnson: 99.625 and 100.21875
Emily Johnson: 200.9375
William Brown: 110.5625

[Colton_Bissegger]

Time to complete 15min
Easy
Steven & Deborah Johnson 199.84375
Emily Johnson 200.9375
William Brown 100.5625

[Jaden_Coles]

Time to Complete: 15 Minutes
Level of Difficulty: Easy-Intermediate (depending on bonus challenge or not)

Solution:
Deborah and Steven Johnson: $99.63 & $100.22 respectively
Emily Johnson: $200.94
William Brown: $100.56

[Jesurun_Ritter]

Time: 25 minutes
Difficulty: moderate
ANSWERS:
Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Clayton_Roberts]

Time: 20 min
Difficulty: Intermediate
Solution:
Steven and Deborah Johnson: 199.84
Emily Johnson: 200.94
William Brown: 100.56

[Michelle_Black]

Steven and Deborah Johnson: 199.84
Emily Johnson: 200.9375
Wiiliam Beown 100.56

[Myla_Schroeppel]

I used ticker and maturity as rows, Sum of Total_PV as a calculated field, and client as a filter. I included maturity as a row rather than as a filter because it allowed for easier filtering of the dates.

I added a date filter for maturity to filter out everything after the given date.

Adding the maturity as a row rather than a filter only allows the exact maturity date to be viewed if desired.

[Jackson_Bond]

Time to complete: 20 minutes
Difficulty: Beginner

[Alexandria_White]

Time to complete: 20 minutes
level beginner
Answers:
Steven and Deborah Johnson - $199.84
Emily Johnson- 200.94
William Brown- 100.56

[Janelle_Dadson]

20 Minutes

Intermediate

[Madelyn_Davis]

Time to complete: 25 min Beginner

Deborah Johnson: 99.63
Steven Johnson: 100.22
Total: 199.85
Emily Johnson: 200.94
William Brown: 100.56

[Christian_Townsend]

Time to complete: 15
Difficulty: Pretty Chill
Answer:
Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Madeline_Larkins]

Time to complete: 25 Min
Level: Intermediate-Beginner

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

[Abigail_Woodbury]

Time To Complete: 15
Difficulty: Beginner
Solution:
Woodbury_Bonds_James_Bonds.xlsx (60.4 KB)

[Will_Snow]

time to complete: 25min
difficulty: decent

Challenge224_Bonds_James_Bonds.xlsx (67.6 KB)

[Collin_Simon]

Challenge224_Bonds_James_Bonds.xlsx (58.5 KB)

There seems to be a slight bug on the first problem, Steven Johnson is spelled Stephen in the data but they don’t return the same values. May be my mistake.

Time: 20 minutes

[Genevieve_Nichols]

1. Steven and Deborah Johnson: $199.84
2. Emily Johnson: $200.94
3. William Brown: $100.56

[Shane_Hawkins]

Time to Complete: 25 Minutes
Rating: Intermediate
Good pivot table practice
Answers:
Steven and Deborah: $199.84
Emily: $200.94
William: $100.56

Challenge224_Bonds_James_Bonds.xlsx (55.6 KB)

[Tyson_Burrup]

Time to complete: 25 minutes.
Level Beginner
Available Money:
Deborah Johnson’s: 99.63
Steven Johnson’s: 100.22
Total of Both: 199.84
Emily Johnson’s: 200.94
William Brown’s: 100.56