Excel homeworks
Pmnguyen1989
spreadsheet_activity_5.xlsxContact Information
| First Name | Last Name | Address | City | State | Zip | Phone | Username |
| Rebecca | Adams | 5352 Honey End | Atlanta | GA | 30389 | 6568038647 | RAdams |
| Steven | Allen | 3455 Blue Impasse | Stone Mountain | GA | 30086 | 6352358744 | SAllen |
| Patrick | Almon | 8528 Dewy View Cove | Atlanta | GA | 30392 | 6015294856 | PAlmon |
| Holly | Amey | 335 Rustic Forest Downs | Marietta | GA | 30066 | 7616537630 | HAmey |
| Safiya | Anand | 8222 Lost River Mount | Norcross | GA | 30091 | 5728008760 | SAnand |
| Dominique | Bardenwerper | 875 Misty Diversion | Stone Mountain | GA | 30086 | 4113633787 | DBarde |
| Grant | Belden | 3872 Gentle Estates | Norcross | GA | 30092 | 5334523074 | GBelde |
| Willie | Boatwright | 788 Hidden Deer Circle | Norcross | GA | 30091 | 3436858847 | WBoatw |
| Maya | Brook | 732 Noble Creek Common | Atlanta | GA | 30398 | 2732494486 | MBrook |
| James | Burnham | 7795 Umber Farms | Atlanta | GA | 31106 | 6897974399 | JBurnh |
| Paul | Clarke | 763 Round Autumn Crossing | Atlanta | GA | 30390 | 5721696492 | PClark |
| Jake | Clonts | 7728 Iron Hollow | Atlanta | GA | 31107 | 6904891564 | JClont |
| Jason | Crane | 2109 Jagged Bear Grounds | Norcross | GA | 30091 | 6360258809 | JCrane |
| Michael | Dean | 3260 Hazy Timber Way | Atlanta | GA | 30396 | 6277813790 | MDean |
| Jason | Fenton | 3056 Dusty Mountain | Marietta | GA | 30066 | 6460433506 | JFento |
| Hannah | Griffiths | 2072 Crystal Dale Circuit | Norcross | GA | 30091 | 6009575264 | HGriff |
| Zachary | Heisey | 4268 Rocky Pointe | Marietta | GA | 30064 | 4804323131 | ZHeise |
| Shelby | Henderson | 6521 Quiet Highlands | Stone Mountain | GA | 30087 | 4013559639 | SHende |
| Diana | Hoydic | 7364 Easy Panda Ramp | Stone Mountain | GA | 30087 | 2795022358 | DHoydi |
| Anthony | Kiprotich | 2246 Grand Private | Alpharetta | GA | 30009 | 4033622418 | AKipro |
| Mark | Kuglar | 2552 Harvest Subdivision | Atlanta | GA | 30399 | 3772815598 | MKugla |
| Vinkle | Leach | 4142 Cotton Anchor Corner | Stone Mountain | GA | 30083 | 6303049773 | VLeach |
| Elizabeth | McClure | 4467 Quaking Pines | Alpharetta | GA | 30004 | 6693106637 | EMcClu |
| Larry | McCray | 5107 Wishing Rise | Atlanta | GA | 31106 | 4810787938 | LMcCra |
| Christopher | McCrite | 3139 Old View | Alpharetta | GA | 30005 | 2727818009 | CMcCri |
| Iesha | Murray | 8348 Heather Path | Atlanta | GA | 31126 | 2696545776 | IMurra |
| Shana | Palmer | 1553 Colonial Spring Pike | Norcross | GA | 30003 | 3970585991 | SPalme |
| Elsa | Parks | 1074 Red Blossom Bend | Atlanta | GA | 30389 | 4387946674 | EParks |
| Courtney | Prempeh | 9088 Tawny By-pass | Alpharetta | GA | 30004 | 2873061991 | CPremp |
| Shanda | Reese | 2919 Green Falls | Stone Mountain | GA | 30088 | 5208909385 | SReese |
| Jasmine | Roberts | 3892 Cozy Corners | Atlanta | GA | 30399 | 6015404906 | JRober |
| Jeremy | Scapillati | 551 High Wood | Atlanta | GA | 31126 | 5765309964 | JScapi |
| David | Scott | 518 Pleasant Quail Close | Stone Mountain | GA | 30088 | 6257972154 | DScott |
| Elizabeth | Simmonds | 956 Sunny Berry Maze | Atlanta | GA | 30390 | 2781489168 | ESimmo |
| Zechariah | Spain | 3927 Broad Hills Walk | Norcross | GA | 30091 | 3827032036 | ZSpain |
| Scylance | Stapleton | 3468 Lazy Robin Highway | Norcross | GA | 30010 | 4243955094 | SStapl |
| Kellee | Stephens | 6320 Clear Pond Line | Atlanta | GA | 31119 | 3123714422 | KSteph |
| Jessica | Taylor | 2903 Merry Parkway | Atlanta | GA | 31120 | 3064356415 | JTaylo |
| Samantha | Turner | 2540 Shady Log Knoll | Norcross | GA | 30071 | 2845547041 | STurne |
| Zoe | Van Meter | 5985 Indian Fawn Key | Norcross | GA | 30091 | 6545897011 | ZVan M |
| Krystyna | Watkins | 912 Sleepy Park | Atlanta | GA | 31107 | 2576576542 | KWatki |
| Michael | Wituszynski | 9579 Thunder Grove Field | Atlanta | GA | 30394 | 5110058215 | MWitus |
| Rebecca | Wright | 410 Stony Elk Row | Norcross | GA | 30092 | 2660534492 | RWrigh |
Complete the following steps to protect this spreadsheet. 1. Lock/protect the entire file so that a password is required to open the workbook. 2. Lock/protect the entire first sheet that is named "Contact Information" so that no one can select any cells in the entire sheet. 3. Lock/protect the entire second sheet that is named "Debt List" and then hide the sheet so it is not visible. 4. Lock/protect the entire third sheet that is named "Personal Problems" but leave it visible (do not hide it). 5. Select the boxes for text on the "Updates" sheet. Make sure that when you lock the sheet that these are still "unlocked" so that you can type in them. Depending on your version of a spreadsheet this may be different. Look at the help on your spreadsheet tool to find out how to leave some cells open for editing.
Debt List
| First Name | Last Name | Amount of Debt | Debt on Credit Cards |
| Rebecca | Adams | $7,878.00 | $4,726.80 |
| Steven | Allen | $12,669.00 | $5,067.60 |
| Patrick | Almon | $10,094.00 | $4,037.60 |
| Holly | Amey | $19,562.00 | $7,824.80 |
| Safiya | Anand | $10,159.00 | $4,063.60 |
| Dominique | Bardenwerper | $16,599.00 | $6,639.60 |
| Grant | Belden | $12,480.00 | $4,992.00 |
| Willie | Boatwright | $11,051.00 | $4,420.40 |
| Maya | Brook | $3,286.00 | $1,971.60 |
| James | Burnham | $12,206.00 | $4,882.40 |
| Paul | Clarke | $17,707.00 | $7,082.80 |
| Jake | Clonts | $11,504.00 | $4,601.60 |
| Jason | Crane | $15,005.00 | $6,002.00 |
| Michael | Dean | $23,579.00 | $9,431.60 |
| Jason | Fenton | $21,699.00 | $8,679.60 |
| Hannah | Griffiths | $7,681.00 | $4,608.60 |
| Zachary | Heisey | $8,153.00 | $4,891.80 |
| Shelby | Henderson | $8,749.00 | $5,249.40 |
| Diana | Hoydic | $21,095.00 | $8,438.00 |
| Anthony | Kiprotich | $10,183.00 | $4,073.20 |
| Mark | Kuglar | $23,690.00 | $9,476.00 |
| Vinkle | Leach | $19,785.00 | $7,914.00 |
| Elizabeth | McClure | $22,036.00 | $8,814.40 |
| Larry | McCray | $6,647.00 | $3,988.20 |
| Christopher | McCrite | $20,397.00 | $8,158.80 |
| Iesha | Murray | $3,056.00 | $1,833.60 |
| Shana | Palmer | $5,702.00 | $3,421.20 |
| Elsa | Parks | $20,010.00 | $8,004.00 |
| Courtney | Prempeh | $20,592.00 | $8,236.80 |
| Shanda | Reese | $10,585.00 | $4,234.00 |
| Jasmine | Roberts | $10,215.00 | $4,086.00 |
| Jeremy | Scapillati | $21,906.00 | $8,762.40 |
| David | Scott | $17,423.00 | $6,969.20 |
| Elizabeth | Simmonds | $20,437.00 | $8,174.80 |
| Zechariah | Spain | $15,558.00 | $6,223.20 |
| Scylance | Stapleton | $11,648.00 | $4,659.20 |
| Kellee | Stephens | $10,906.00 | $4,362.40 |
| Jessica | Taylor | $10,673.00 | $4,269.20 |
| Samantha | Turner | $17,952.00 | $7,180.80 |
| Zoe | Van Meter | $18,436.00 | $7,374.40 |
| Krystyna | Watkins | $19,308.00 | $7,723.20 |
| Michael | Wituszynski | $4,370.00 | $2,622.00 |
| Rebecca | Wright | $21,638.00 | $8,655.20 |
Complete the following steps to protect this spreadsheet. 1. Lock/protect the entire file so that a password is required to open the workbook. 2. Lock/protect the entire first sheet that is named "Contact Information" so that no one can select any cells in the entire sheet. 3. Lock/protect the entire second sheet that is named "Debt List" and then hide the sheet so it is not visible. 4. Lock/protect the entire third sheet that is named "Personal Problems" but leave it visible (do not hide it). 5. Select the boxes for text on the "Updates" sheet. Make sure that when you lock the sheet that these are still "unlocked" so that you can type in them. Depending on your version of a spreadsheet this may be different. Look at the help on your spreadsheet tool to find out how to leave some cells open for editing.
Personal Problems
| First Name | Last Name | Personal Problems Caused by Debt | Persoanal Problems that Caused the debt |
| Rebecca | Adams | Loss of job | No money management skills |
| Steven | Allen | Divorce | Gambling problem |
| Patrick | Almon | Separated from spouse | No money management skills |
| Holly | Amey | Began drinking | Too elaborate lifestyle |
| Safiya | Anand | Avoiding phone calls | No money management skills |
| Dominique | Bardenwerper | Utilities turned off | Gambling problem |
| Grant | Belden | Loss of job | No money management skills |
| Willie | Boatwright | Divorce | No money management skills |
| Maya | Brook | Separated from spouse | Too elaborate lifestyle |
| James | Burnham | Began drinking | No money management skills |
| Paul | Clarke | Utilities turned off | Gambling problem |
| Jake | Clonts | Loss of job | No money management skills |
| Jason | Crane | Divorce | Gambling problem |
| Michael | Dean | Avoiding phone calls | Too elaborate lifestyle |
| Jason | Fenton | Avoiding phone calls | Too elaborate lifestyle |
| Hannah | Griffiths | Utilities turned off | Gambling problem |
| Zachary | Heisey | Loss of job | No money management skills |
| Shelby | Henderson | Divorce | Gambling problem |
| Diana | Hoydic | Separated from spouse | No money management skills |
| Anthony | Kiprotich | Began drinking | Too elaborate lifestyle |
| Mark | Kuglar | Utilities turned off | No money management skills |
| Vinkle | Leach | Loss of job | Too elaborate lifestyle |
| Elizabeth | McClure | Divorce | No money management skills |
| Larry | McCray | Avoiding phone calls | Gambling problem |
| Christopher | McCrite | Divorce | No money management skills |
| Iesha | Murray | Separated from spouse | Gambling problem |
| Shana | Palmer | Began drinking | Too elaborate lifestyle |
| Elsa | Parks | Utilities turned off | Too elaborate lifestyle |
| Courtney | Prempeh | Loss of job | Gambling problem |
| Shanda | Reese | Divorce | No money management skills |
| Jasmine | Roberts | Avoiding phone calls | Too elaborate lifestyle |
| Jeremy | Scapillati | Utilities turned off | No money management skills |
| David | Scott | Loss of job | Gambling problem |
| Elizabeth | Simmonds | Divorce | No money management skills |
| Zechariah | Spain | Avoiding phone calls | Gambling problem |
| Scylance | Stapleton | Divorce | Too elaborate lifestyle |
| Kellee | Stephens | Utilities turned off | Too elaborate lifestyle |
| Jessica | Taylor | Loss of job | Gambling problem |
| Samantha | Turner | Divorce | No money management skills |
| Zoe | Van Meter | Separated from spouse | Too elaborate lifestyle |
| Krystyna | Watkins | Began drinking | No money management skills |
| Michael | Wituszynski | Utilities turned off | Gambling problem |
| Rebecca | Wright | Divorce | No money management skills |
Complete the following steps to protect this spreadsheet. 1. Lock/protect the entire file so that a password is required to open the workbook. 2. Lock/protect the entire first sheet that is named "Contact Information" so that no one can select any cells in the entire sheet. 3. Lock/protect the entire second sheet that is named "Debt List" and then hide the sheet so it is not visible. 4. Lock/protect the entire third sheet that is named "Personal Problems" but leave it visible (do not hide it). 5. Select the boxes for text on the "Updates" sheet. Make sure that when you lock the sheet that these are still "unlocked" so that you can type in them. Depending on your version of a spreadsheet this may be different. Look at the help on your spreadsheet tool to find out how to leave some cells open for editing.
Updates
| First Name | Last Name | Notes from Meeting 1 | Progress Week 1 | Notes from Week 2 | Progress Week 2 | Notes from Week 3 | Progress Week 3 | Notes from Week 4 | Progress Week 4 |
| Rebecca | Adams | ||||||||
| Steven | Allen | ||||||||
| Patrick | Almon | ||||||||
| Holly | Amey | ||||||||
| Safiya | Anand | ||||||||
| Dominique | Bardenwerper | ||||||||
| Grant | Belden | ||||||||
| Willie | Boatwright | ||||||||
| Maya | Brook | ||||||||
| James | Burnham | ||||||||
| Paul | Clarke | ||||||||
| Jake | Clonts | ||||||||
| Jason | Crane | ||||||||
| Michael | Dean | ||||||||
| Jason | Fenton | ||||||||
| Hannah | Griffiths | ||||||||
| Zachary | Heisey | ||||||||
| Shelby | Henderson | ||||||||
| Diana | Hoydic | ||||||||
| Anthony | Kiprotich | ||||||||
| Mark | Kuglar | ||||||||
| Vinkle | Leach | ||||||||
| Elizabeth | McClure | ||||||||
| Larry | McCray | ||||||||
| Christopher | McCrite | ||||||||
| Iesha | Murray | ||||||||
| Shana | Palmer | ||||||||
| Elsa | Parks | ||||||||
| Courtney | Prempeh | ||||||||
| Shanda | Reese | ||||||||
| Jasmine | Roberts | ||||||||
| Jeremy | Scapillati | ||||||||
| David | Scott | ||||||||
| Elizabeth | Simmonds | ||||||||
| Zechariah | Spain | ||||||||
| Scylance | Stapleton | ||||||||
| Kellee | Stephens | ||||||||
| Jessica | Taylor | ||||||||
| Samantha | Turner | ||||||||
| Zoe | Van Meter | ||||||||
| Krystyna | Watkins | ||||||||
| Michael | Wituszynski | ||||||||
| Rebecca | Wright |
Complete the following steps to protect this spreadsheet. 1. Lock/protect the entire file so that a password is required to open the workbook. 2. Lock/protect the entire first sheet that is named "Contact Information" so that no one can select any cells in the entire sheet. 3. Lock/protect the entire second sheet that is named "Debt List" and then hide the sheet so it is not visible. 4. Lock/protect the entire third sheet that is named "Personal Problems" but leave it visible (do not hide it). 5. Select the boxes for text on the "Updates" sheet. Make sure that when you lock the sheet that these are still "unlocked" so that you can type in them. Depending on your version of a spreadsheet this may be different. Look at the help on your spreadsheet tool to find out how to leave some cells open for editing.
