Instructions Assign the credit score scale descriptor by using a nested IF function using Assign the credit score scale descriptor by using an IFS function Penalty Points Did not use a 3D reference to the other sheet Forgot to enter your name Points Possible 5 5 Credit Score Categories Credit Credit Score Scale Descriptor Using Credit Score Scale Descriptor Using Name Score James 719 Mary 544 John 761 Patricia 662 Robert 660 Jennifer 557 Michael 625 Linda 450 William 690 Elizabeth 696 David 485 Barbara 795 Richard 778 Nested IF Function IFS function -2 5 Score
Added by Carla S.
Close
Step 1
Step 1: Show more…
Show all steps
Your feedback will help us improve your experience
Donna Densmore and 78 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Modify the data in the Base Data worksheet in the Excel file Credit Risk Data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise
Donna D.
You need to provide a rate for each customer based on their credit score. Any user who has a score less than 600 should be denied. a. Display the Approval Form worksheet and create an IF statement in cell B13 to determine if the applicant is eligible for a personal loan. Use the criteria below as part of your logic statement: - Credit Score < 600 = "Denied" - Credit Score >= 600 = "Approved" c. Create a VLOOKUP function in cell B14 that uses the Credit Score in cell B9 to generate a rate based on the array in cells I4:J11. Determine Rate You will calculate the payment quote for each customer. d. Insert a row in the worksheet above row 15 (Payment). e. Type Periodic Rate: in cell A15. f. Calculate the periodic rate of the loan in cell B15. g. Generate the loan payment in cell B16. Determine Rate You will create a working list of all existing accounts that provides the number of days remaining on their loan and an overall look at all accounts maturity dates. h. Display the Existing Accounts worksheet and calculate the number of days remaining for each existing account. i. Calculate the maximum number of Days Remaining for all existing accounts in cell C17. j. Calculate the minimum number of Days Remaining for all existing accounts in cell C18. k. Calculate the average number of Days Remaining for all existing accounts in cell C19.
Supreeta N.
Write a nested IF function in cell D3 that assigns a grade of A for scores between 90 and 100, a grade of B for scores between 80 and 89, a grade of C for scores between 70 and 79, and a grade of F for scores below 70. (Hint: Search in Help for nested IF when constructing your function.) Copy this function to cells D4:D19. 2. Calculate the average grade in cell B21. In cells C21 and D21, use a formula to determine whether the average grade is a passing grade, and the overall grade achieved by the class.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD