224|EXCEL – Bonds, James Bonds

[Aaron_Christensen]

Time: 17 minutes.
Main challenge is beginner. Intermediate with additional challenge.
Solutions were:
Steven and Deborah 198.84
Emilu Johnson 200.94
William Brown 100.56

[Nick_Price]

Time to Complete: 25 minutes
Difficulty: Intermediate

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

[Ava_Lassiter]

Time to complete: 30 min
Level: Intermediate
Solution:

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

[Abigail_Dillon]

Time: 30 minutes
rating: beginner
solution:
steven and deborah johnson: $199.85
emily johnson: $200.94
William brown: $100.56

[Michael_Burgess]

Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[Landon_Wells]

Time to complete: 20 min
Difficulty: Beginner
Solution:
Deborah Johnson: 99.63 (1 bond)
Steven Johnson: 100.22 (1 bond)
Emily Johnson: 200.94 (2 bonds)
William Brown: 100.56 (1 bond)

[Griffin_Karras]

Solutions:
Challenge224_Bonds_James_Bonds Griffin.xlsx (59.8 KB)

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

[George_Earnest]

Time to Complete: 20 minutes
Difficulty: Intermediate

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

[Olivia_Egbert]

Time to complete 25 min
Difficulty: beginner
Solution:
Steven & Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Crew_Jensen]

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

[Sam_Herbert]

Time to complete: 25 minutes
Rating Beginner

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

[Kaden_Westerlind]

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

[Charles_Winfield]

Time to Complete: 15 minutes
Difficulty: Beginner
Very fun intro to pivot tables!

Steven and Deborah:
|TMBKHMC-9Y| $99.63 |1|
|TMBRFZX-7Y| $100.22 |1|
|Grand Total| $199.84 |2|

Emily Johnson:
|TMBRFZX-30Y| $200.94 |2|
|Grand Total| $200.94 |2|

William Brown:
|LMKXBES-50Y| $100.56 |1|
|Grand Total| $100.56 |1|

[Thomas_Sanders]

Time to Complete 22 Min
Difficulty: Beginner
Steven and Deborah Johnson 99.63, 100.22
Emily Johnson 200.94
William Brown 100.56

[George_Guo]

Steven and Deborah Johnson: 99.625 and 100.21875

Emily Johnson: 200.9375

William Brown: 100.5625

[Chase_Torgesen]

Time- 40 mins
Difficulty- Intermediate

Steven and Deb- 198.84
Emily Johnson- 200.94
William Brown- 100.56

[David_Fox]

Time: 25 min
Difficulty: Beginner
Solution:

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

[Adam_Peterson]

Time to complete: 40 min
Difficulty: Intermediate

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

[Josue_Quilantan]

10 minutes
Basic review of PivotTables

1. 199.38
2. 200.94
3. 100.56