Coin Collection Spreadsheet — excelguider.com - Free Printable

The image provided is a collection of four tables tracking a coin collection. The tables are for Dollars, Half Dollars, Quarters, and Dimes.

Since there is no specific question asked in the prompt, I will analyze the data to provide a summary of the collection's status based on the "Total by Type" columns, which aggregate the counts for each coin category. This is the most logical "solution" to understanding the data presented.

Step 1: Analyze the Dollar Table
- The table lists various dollar coins (Sacagawea, Presidential, Susan B. Anthony, etc.).
- The last column, "Total by Type," sums up the "Have" count for each row.
- Scanning down the "Total by Type" -> "Have" column:
- Sacagawea: 0
- Presidential Dollar: 0
- Susan B. Anthony: 0
- Eisenhower: 0
- Peace: 0
- Morgan: 0
- Seated Liberty: 0
- Draped Bust: 0
- Flowing Hair: 0
- The bottom row "Total by Mint" shows a total of 0 for all mints (D, P, S, No Mark, O, CC).
- Conclusion for Dollars: The collector has 0 dollar coins.

Step 2: Analyze the Half Dollar Table
- The table lists Half Dollars (Kennedy Head, Franklin Head, Walking Liberty, Barber, Seated Liberty, Turban Head, Draped Bust, Flowing Hair).
- Scanning the "Total by Type" -> "Have" column:
- Kennedy Head: 95
- Franklin Head: 35
- Walking Liberty: 66
- Barber: 72
- Seated Liberty: 127
- Turban Head: 77
- Draped Bust: 17
- Flowing Hair: 4
- Let's verify the grand total at the bottom right ("Total by Mint" -> "Total by Type" -> "Have"): It says 493.
- Let's double-check the sum: $95 + 35 + 66 + 72 + 127 + 77 + 17 + 4$.
- $95 + 35 = 130$
- $130 + 66 = 196$
- $196 + 72 = 268$
- $268 + 127 = 395$
- $395 + 77 = 472$
- $472 + 17 = 489$
- $489 + 4 = 493$.
- Conclusion for Half Dollars: The collector has 493 half dollars.

Step 3: Analyze the Quarter Table
- The table lists Quarters (America The Beautiful, D.C. & U.S. Territories, State Quarters, Washington Head, Standing Liberty, Liberty Head, Seated Liberty, Liberty Cap, Draped Bust, Birch).
- Scanning the "Total by Type" -> "Have" column:
- America The Beautiful: 50
- D.C. & U.S. Territories: 12
- State Quarters: 100
- Washington Head: 153
- Standing Liberty: 38
- Liberty Head: 74
- Seated Liberty: 117
- Liberty Cap: 27
- Draped Bust: 6
- Birch: 2
- Let's verify the grand total at the bottom right: It says 579.
- Let's double-check the sum: $50 + 12 + 100 + 153 + 38 + 74 + 117 + 27 + 6 + 2$.
- $50 + 12 = 62$
- $62 + 100 = 162$
- $162 + 153 = 315$
- $315 + 38 = 353$
- $353 + 74 = 427$
- $427 + 117 = 544$
- $544 + 27 = 571$
- $571 + 6 = 577$
- $577 + 2 = 579$.
- Conclusion for Quarters: The collector has 579 quarters.

Step 4: Analyze the Dime Table
- The table lists Dimes (Roosevelt Head, Mercury Head, Liberty Head, Seated Liberty, Liberty Cap, Draped Bust).
- Scanning the "Total by Type" -> "Have" column:
- Roosevelt Head: 149
- Mercury Head: 81
- Liberty Head: 76
- Seated Liberty: 131
- Liberty Cap: 34
- Draped Bust: 16
- Let's verify the grand total at the bottom right: It says 487.
- Let's double-check the sum: $149 + 81 + 76 + 131 + 34 + 16$.
- $149 + 81 = 230$
- $230 + 76 = 306$
- $306 + 131 = 437$
- $437 + 34 = 471$
- $471 + 16 = 487$.
- Conclusion for Dimes: The collector has 487 dimes.

Step 5: Calculate the Total Collection Size
To find the total number of coins in the entire collection, we sum the totals from each table:
- Dollars: 0
- Half Dollars: 493
- Quarters: 579
- Dimes: 487

Total Coins = $0 + 493 + 579 + 487$
- $493 + 579 = 1072$
- $1072 + 487 = 1559$

The student likely needs to know the total count or the breakdown. Since no specific question was asked, providing the total count of coins in the collection is the most comprehensive answer derived from the data.

Final Answer:
The total number of coins in the collection is 1,559.

Breakdown by type:
- Dollars: 0
- Half Dollars: 493
- Quarters: 579
- Dimes: 487