224|EXCEL – Bonds, James Bonds

[Canon_Rogers]

Rating: Intermediate
Time: 20 minutes
Comments: Good practice problem for Pivot Tables!

[Andrew_Wells]

Time to complete: 25 min
Rating: Beginner
Solution:

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

[Dayna_Ranta]

Time to complete: 20 minutes
Rating: Intermediate
Emily Johnson: 200.94
Steven and Deborah Johnson: 198.84
William Brown: 100.56

[Benton_Worthen]

Time to complete: 20 min
Rating: Intermediate

1. 
2. 
3. 

[Josh_Graham]

Rating Beginner
Time to Complete 10
Steven Johnson & Deborah Johnson $199.84
Emily Johnson $200.93
William Brown $100.56

[Clyn_Hansen]

Time to complete: 30 minutes
Difficulty: Intermediate
Deborah: $99.63
Stephen: $100.22
Emily: $200.94
William: $100.56

[Lainey_Jackson]

Time to complete: 20 minutes

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

[Gavin_Ross]

Time to complete: 20 min
Difficulty level: Beginner
Solutions:

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

[Andrew_Benson]

Time to Complete: 20 minutes
Difficulty: Beginner

Review of Pivot Tables

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

[Travis_Walker]

2.

3.

[Easton_Edwards]

Time to Complete: 20 minutes
Rating: Beginner

[Judd_Belnap]

Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[Samantha_Cassell]

Time to complete: 15 minutes
Difficulty: Easy
Solutions:

Steven Johnson: 100.22
Deborah Johnson: 99.63

Emily Johnson: 200.94

William Brown: 100.56

[Layton_Allred]

Time to Complete: 30 min
Rating: Beginner
Solutions:
Steven & Deborah: 199.84
Emily Johnson: 200.94
William Brown: 100.56

[Connor_Roddy]

Time to complete: 30 minutes
Difficulty: Intermediate
I am not the most experienced when it comes to Excel so I may have taken longer on this than most people would. But this was a good challenge that I learned a lot from!
Here are the totals that I got:
Steven and Deborah: 198.84
Emily: 200.94
William: 100.56

[Claire_Campbell]

Time to complete: 20 minutes
Difficulty: Beginner
Solution:
Deborah and Steven Johnson - $199.84
Emily Johnson: $200.94
William Brown: $100.56

I just used filters and a simple sum function. There was probably a more automated way to go about it, but for the challenge it seemed like the quickest and easiest solution was by simply filtering and adding the Total PV of the applicable stock. However, I could’ve done the equation wrong and summed wrong numbers, but this is my best answer.

[Ava_Egan]

Time to Complete: 30 minutes
Difficulty: Intermediate
Solutions:
Steven and Deborah Johnson: 99.63 and 100.22
Emily Johnson: 200.94
William Brown: 100.56

[Ryan_Garrett]

Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[RJ_Bateman]

Steven and Deborah Johnson
99.625, 100.21875
Emily Johnson
200.9375
William Brown
100.5625

[Austin_Smith]

Took me 30 min. Kinda tough to remember how to do it.