224|EXCEL – Bonds, James Bonds

[Charlotte_Owsley]

Time to complete 30 minutes
Intermediate

Steven and Deborah 199.84
Emily Johnson 200.94
William Brown 100.56

[Adlee_Baird]

This was honestly pretty hard cause I didn’t remember a thing about pivot tables but eventually i got it figured out.
Solutions
Deborah and Steven Johnson: Total $199.84
Emily Johnson: $200.94
William Brown: $100.56

[Aubrey_Beals]

Time to complete: 35 mins
rating: intermediate

solution-
Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[Ethan_Plothow]

Time to complete: 15 mins
Difficulty: Easy
Steven and Deborah Johnson: 99.625 and 100.21875
Emily Johnson: 200.9375
William Brown: 110.5625

[David_Hulme]

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

[Gwen_Chandler]

Time: 20 Min
Level: Intermediate
Deborah and Stephen: $198.00
Emily Johnson: $200.00
William Brown: $100.00

Challenge224_Bonds_James_Bonds.xlsx (79.7 KB)

[Scott_Johnston]

Time: 30 min
Level: Beginner
Solution:

Steven and Deborah:

Emily:

William:

[Cooper_Wise]

Time to complete: 15 min
Difficulty: Beginner
Solution:
|Deborah Johnson| $99.63 |
|Steven Johnson| $100.22 |
|Emily Johnson| $200.94 |
|William Brown| $100.56 |

[marcushurd]

Time to Complete: 25 min
Rating: Fine

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

[Kameron_K_Sakamoto]

Time to complete 30min
Level: Intermediate

Deborah Johnson: $99.63
Steven Johnson: $100.22
Emily Johnson: $200.94
William Brown: $100.56

[Ava_Danko]

Time: 20 Minutes
Difficulty: Easy

[Detroit_Kane]

Time to complete: 15 minutes
Difficulty: Intermediate

Deborah: $99.63 & Stephen: $100.22 = $199.84

Emily: $200.94
William: $100.56

[Luke_Robinson]

Time to complete: 15 minutes
Difficulty Level: Intermediate
Good review of Pivot Tables

Steven & Deborah Johnson: 199.84
Emily Johnson: 200.93
William Brown: 100:56
Challenge224_Bonds_James_Bonds.xlsx (56.1 KB)

[Rylee_Schriever]

Time to complete: 25 minutes, the pivot tables were a little confusing at first
Level: Beginner-Intermediate
Deborah Johnson: $99.63
Steven Johnson: $100.22
Emily Johnson: $200.94
William Brown: $100.56

[Lucas_Spillett]

Time to Complete: 10 Mins
Rating: Beginner
Solutions

[Lily_Flint]

Time to complete: 10 min.
Rating: Beginner
Steven and Deborah Johnson: 199.84
Emily Johnson: 200.94
William Brown: 100.56

[Tyler_Rhoads]

Time: 15 Min
Rating: Easy
Created a pivot table and filtered by specified clients and maturity date.

Steven and Deborah 198.84
Emily Johnson 200.94
William Brown 100.56

[Tyler_Herget]

Time to complete: 10 min
Difficulty: Easy
Solution:

[Tiana_Holt]

Time: 25
Difficulty: beginner

Steven and Deborah:199.85
Emily: 200.94
William: 100.56

[Hailey_Smith]

Time to Complete: 15 minutes
Level: Beginner

Steve & Deborah Johnson: $199.84

Emily Johnson: $200.94

William Brown: $100.56