Help Tommy by completing the following:
1. Use the AND function to 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 remove these if it does insert them.
2. Use the OR function to determine if someone has either filed for bankruptcy or been denied a loan.
3. Use the 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 attempts to find the correct combination.
A B C SSN D E F G H - K - M N
1 Last Name Credit Score 1 Credit Score 2 Credit Score 3 Credit Score Average Income 1 Income 2 Debt 1 Debt 2 Recent bankruptcy f Recent denial Income/Payment Ratio
2 Ram Aring 4105656724 799 793 804 799 $72,441.00 $8,653.00 $76,713.00 $10,357.00 NO Yes 0.32
3 Charles Bartlett 1894841225 786 777 796 786 $30,391.00 $0.00 $72,177.00 $6,233.00 NO No 0.62
4 Tina Baumann 3215215602 623 618 622 621 $51,465.00 $0.00 $60,954.00 $7,751.00 NO No 0.34
5 Samrat Beard 1107048919 661 651 670 661 $57,483.00 $0.00 $69,784.00 $6,124.00 NO No 0.35
6 Brian Brannen 4396737900 359 364 368 364 $32,968.00 $6,468.00 $55,384.00 $8,188.00 NO No 0.48
7 Kevin Butterworth 5015415788 543 534 553 543 $40,595.00 $0.00 $52,340.00 $7,451.00 NO No 0.36
8 Podd Cameron 2971702237 552 557 555 555 $61,145.00 $8,441.00 $83,383.00 $10,914.00 NO No 0.41
9 Deanna Cline 1022704034 648 652 659 653 $74,024.00 $3,535.00 $85,464.00 $8,074.00 YES No 0.36
10 Laura Davis 8068967986 721 713 727 720 $54,224.00 $0.00 $84,474.00 $8,510.00 NO No 0.47
11 Sourav Dicken 7369508117 837 835 837 836 $37,400.00 $7,866.00 $52,900.00 $0.00 NO No 0.41
12 Rabonne Doyle 4335768124 626 623 634 628 $41,146.00 $0.00 $67,292.00 $6,587.00 NO No 0.44
13 Croix Dunn 7072545727 337 341 336 338 $46,209.00 $8,353.00 $65,045.00 $6,064.00 NO No 0.39
14 Alfred Garber 2919765299 634 626 631 630 $28,480.00 $3,410.00 $71,641.00 $7,026.00 NO No 0.74
15 Joseph Harrison 3502548552 493 483 490 489 $49,987.00 $7,603.00 $60,684.00 $7,250.00 NO No 0.35
16 Jacob Hill 6444876267 335 336 342 338 $57,692.00 $0.00 $56,729.00 $6,976.00 NO No 0.28
17 Timika Horn 3002352478 778 775 776 776 $37,823.00 $0.00 $72,756.00 $0.00 NO No 0.49
18 Brian Humphrey 346 337 341 341 $56,884.00 $9,892.00 $74,717.00 $50.00 NO No 0.36
19 Kyra Janus 5985373133 692 680 702 691 $56,287.00 $3,522.00 $71,422.00 $6,292.00 NO No 0.39
20 Catrice Kenny 6450252115 657 657 664 659 $68,768.00 $9,238.00 $92,108.00 $10,523.00 NO No 0.39
21 Jaline Lopez 7434254351 787 786 795 789 $55,617.00 $0.00 $54,921.00 $6,859.00 NO No 0.31
22 Charles Moore 2941480104 774 773 784 777 $26,830.00 $0.00 $54,683.00 $5,045.00 NO No 0.49
23 Kelley Nicholson 5159884715 563 556 574 564 $43,770.00 $7,257.00 $69,994.00 $8,195.00 NO No 0.46
24 Kevin Okoli 4551709178 723 725 722 723 $29,382.00 $0.00 $70,826.00 $5,404.00 NO No 0.58
25 Benjamin O'Neill 909508264 736 724 740 733 $46,044.00 $0.00 $61,768.00 $0.00 NO No 0.40
26 Mariana Roberts 5458134250 438 436 435 436 $36,736.00 $9,445.00 $76,469.00 $11,740.00 NO No 0.57
27 Kenneth Santos 2532527197 556 547 552 552 $44,236.00 $3,082.00 $72,666.00 $6,283.00 NO No 0.50
28 Andrew Stanley 4795511586 567 561 570 566 $41,882.00 $0.00 $64,593.00 $5,130.00 NO No 0.46
29 Emily Valeus 1440710060 476 464 483 474 $56,392.00 $4,038.00 $72,431.00 $0.00 NO No 0.39
30 Tom Werner 8178616040 424 421 432 426 $74,397.00 $50.00 $93,433.00 $10,836.00 YES No 0.40
31 Priscilla Werner 4238366166 805 805 804 805 $53,951.00 $9,712.00 $75,791.00 $10,712.00 NO No 0.41
32 Keith Wright 7504795050 721 717 716 718 $68,246.00 $7,747.00 $106,124.00 $11,536.00 NO No 0.46
33 Johnny Wynter 5109529140 503 502 499 501 $47,959.00 $4,549.00 $64,771.00 $5,571.00 NO No 0.40
