Excel
Pmnguyen1989
spreadsheet_activity_7.xlsxTommy's Applicant Data
| First Name | Last Name | SSN | Credit Score 1 | Credit Score 2 | Credit Score 3 | Credit Score Average | Income 1 | Income 2 | Debt 1 | Debt 2 | Recent bankruptcy | Redent denial | Income/Payment Ratio |
| Ram | Aring | 4105656724 | 799 | 793 | 804 | 799 | $72,441.00 | $8,653.00 | $76,713.00 | $10,357.00 | NO | Yes | 0.32 |
| Charles | Bartlett | 1894841225 | 786 | 777 | 796 | 786 | $30,391.00 | $0.00 | $72,177.00 | $6,233.00 | NO | No | 0.62 |
| Tina | Baumann | 3215215602 | 623 | 618 | 622 | 621 | $51,465.00 | $0.00 | $60,954.00 | $7,751.00 | NO | No | 0.34 |
| Samrat | Beard | 1107048919 | 661 | 651 | 670 | 661 | $57,483.00 | $0.00 | $69,784.00 | $6,124.00 | NO | No | 0.35 |
| Brian | Brannen | 4396737900 | 359 | 364 | 368 | 364 | $32,968.00 | $6,468.00 | $55,384.00 | $8,188.00 | NO | No | 0.48 |
| Kevin | Butterworth | 5015415788 | 543 | 534 | 553 | 543 | $40,595.00 | $0.00 | $52,340.00 | $7,451.00 | NO | No | 0.36 |
| Todd | Cameron | 2971702237 | 552 | 557 | 555 | 555 | $61,145.00 | $8,441.00 | $83,383.00 | $10,914.00 | NO | No | 0.41 |
| Deanna | Cline | 1022704034 | 648 | 652 | 659 | 653 | $74,024.00 | $3,535.00 | $85,464.00 | $8,074.00 | YES | No | 0.36 |
| Laura | Davis | 8068967986 | 721 | 713 | 727 | 720 | $54,224.00 | $0.00 | $84,474.00 | $8,510.00 | NO | No | 0.47 |
| Sourav | Dicken | 7369508117 | 837 | 835 | 837 | 836 | $37,400.00 | $7,866.00 | $52,900.00 | $0.00 | NO | No | 0.41 |
| Rabonne | Doyle | 4335768124 | 626 | 623 | 634 | 628 | $41,146.00 | $0.00 | $67,292.00 | $6,587.00 | NO | No | 0.44 |
| Croix | Dunn | 7072545727 | 337 | 341 | 336 | 338 | $46,209.00 | $8,353.00 | $65,045.00 | $6,064.00 | NO | No | 0.39 |
| Alfred | Garber | 2919765299 | 634 | 626 | 631 | 630 | $28,480.00 | $3,410.00 | $71,641.00 | $7,026.00 | NO | No | 0.74 |
| Joseph | Harrison | 3502548552 | 493 | 483 | 490 | 489 | $49,987.00 | $7,603.00 | $60,684.00 | $7,250.00 | NO | No | 0.35 |
| Jacob | Hill | 6444876267 | 335 | 336 | 342 | 338 | $57,692.00 | $0.00 | $56,729.00 | $6,976.00 | NO | No | 0.28 |
| Timika | Horn | 3002352478 | 778 | 775 | 776 | 776 | $37,823.00 | $0.00 | $72,756.00 | $0.00 | NO | No | 0.49 |
| Brian | Humphrey | 346 | 337 | 341 | 341 | $56,884.00 | $9,892.00 | $74,717.00 | $0.00 | NO | No | 0.36 | |
| Kyra | Janus | 5985373133 | 692 | 680 | 702 | 691 | $56,287.00 | $3,522.00 | $71,422.00 | $6,292.00 | NO | No | 0.39 |
| Catrice | Kenny | 6450252115 | 657 | 657 | 664 | 659 | $68,768.00 | $9,238.00 | $92,108.00 | $10,523.00 | NO | No | 0.39 |
| Jaline | Lopez | 7434254351 | 787 | 786 | 795 | 789 | $55,617.00 | $0.00 | $54,921.00 | $6,859.00 | NO | No | 0.31 |
| Charles | Moore | 2941480104 | 774 | 773 | 784 | 777 | $26,830.00 | $0.00 | $54,683.00 | $5,045.00 | NO | No | 0.49 |
| Kelley | Nicholson | 5159884715 | 563 | 556 | 574 | 564 | $43,770.00 | $7,257.00 | $69,994.00 | $8,195.00 | NO | No | 0.46 |
| Kevin | Okoli | 4551709178 | 723 | 725 | 722 | 723 | $29,382.00 | $0.00 | $70,826.00 | $5,404.00 | NO | No | 0.58 |
| Benjamin | O'Neill | 909508264 | 736 | 724 | 740 | 733 | $46,044.00 | $0.00 | $61,768.00 | $0.00 | NO | No | 0.40 |
| Mariana | Roberts | 5458134250 | 438 | 436 | 435 | 436 | $36,736.00 | $9,445.00 | $76,469.00 | $11,740.00 | NO | No | 0.57 |
| Kenneth | Santos | 2532527197 | 556 | 547 | 552 | 552 | $44,236.00 | $3,082.00 | $72,666.00 | $6,283.00 | NO | No | 0.50 |
| Andrew | Stanley | 4795511586 | 567 | 561 | 570 | 566 | $41,882.00 | $0.00 | $64,593.00 | $5,130.00 | NO | No | 0.46 |
| Emily | Valeus | 1440710060 | 476 | 464 | 483 | 474 | $56,392.00 | $4,038.00 | $72,431.00 | $0.00 | NO | No | 0.39 |
| Tom | Werner | 8178616040 | 424 | 421 | 432 | 426 | $74,397.00 | $0.00 | $93,433.00 | $10,836.00 | YES | No | 0.40 |
| Priscilla | Werner | 4238366166 | 805 | 805 | 804 | 805 | $53,951.00 | $9,712.00 | $75,791.00 | $10,712.00 | NO | No | 0.41 |
| Keith | Wright | 7504795050 | 721 | 717 | 716 | 718 | $68,246.00 | $7,747.00 | $106,124.00 | $11,536.00 | NO | No | 0.46 |
| Johnny | Wynter | 5109529140 | 503 | 502 | 499 | 501 | $47,959.00 | $4,549.00 | $64,771.00 | $5,571.00 | NO | No | 0.40 |
Select and delete this box. Instructions are found on the next sheet. You will, however, reference the data found on this sheet.
Tommy's Helpful Data
| First Name | Last Name | Complete Applicant | Issue in Recent Activity | Credit Score 1 Check | Credit Score 2 Check | Credit Score 3 Check | Preapproval |
| Ram | Aring | ||||||
| Charles | Bartlett | ||||||
| Tina | Baumann | ||||||
| Samrat | Beard | ||||||
| Brian | Brannen | ||||||
| Kevin | Butterworth | ||||||
| Todd | Cameron | ||||||
| Deanna | Cline | ||||||
| Laura | Davis | ||||||
| Sourav | Dicken | ||||||
| Rabonne | Doyle | ||||||
| Croix | Dunn | ||||||
| Alfred | Garber | ||||||
| Joseph | Harrison | ||||||
| Jacob | Hill | ||||||
| Timika | Horn | ||||||
| Brian | Humphrey | ||||||
| Kyra | Janus | ||||||
| Catrice | Kenny | ||||||
| Jaline | Lopez | ||||||
| Charles | Moore | ||||||
| Kelley | Nicholson | ||||||
| Kevin | Okoli | ||||||
| Benjamin | O'Neill | ||||||
| Mariana | Roberts | ||||||
| Kenneth | Santos | ||||||
| Andrew | Stanley | ||||||
| Emily | Valeus | ||||||
| Tom | Werner | ||||||
| Priscilla | Werner | ||||||
| Keith | Wright | ||||||
| Johnny | Wynter |
Help Tommy by completing the following. 1. Use the AND function can help determine if the application is complete. NOTE: Sometimes when you are selecting data from different pages, the spreadsheet will also insert the dollar signs to help make cell references absolute. You will need to manually removed these if it does insert them. 2. Use the OR can determine if someone has either filed for bankruptcy or been denied a loan. 3. Use IF function to determine if there are any issues with the consistency of the credit score. Check to see if any of the scores are 10 points higher than that individual's average. 4. Use the AND function to determine if an applicant has met the requirements to be preapproved for final consideration by the committee. NOTE: In general when you are entering text into an "IF" statement you have to surround it with quotes. However, there are times when, if the text in the cell you are pointing to is the result of a logical function, that the quotes are not necessary. This will be different based on the version of your spreadsheet you are using. However, the final IF statement will work. You just may have to give it a few attemps to find the correct combination.
