{"id":104269,"date":"2022-06-06T00:00:00","date_gmt":"2022-06-06T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/06\/06\/cis250-advanced-excel\/"},"modified":"2022-06-06T00:00:00","modified_gmt":"2022-06-06T00:00:00","slug":"cis250-advanced-excel","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/cis250-advanced-excel\/","title":{"rendered":"CIS250 \u2013 Advanced Excel"},"content":{"rendered":"<p>CIS250 \u2013 Advanced Excel<\/p>\n<p>Case Study 1<\/p>\n<p>Copyright 2022 Post University, ALL RIGHTS RESERVED<\/p>\n<p>Due Date: 11:59 pm EST Sunday of Unit 2<\/p>\n<p>Points: 100<\/p>\n<p>Overview:<\/p>\n<p>In this case study, you have been tasked with generating a loan approval workbook that<\/p>\n<p>will determine if an applicant is eligible for a personal loan and if so, what the loan rate<\/p>\n<p>should be based on a set of pre-defined criteria. The bank manager has created the<\/p>\n<p>basic layout of the application she wants to use but has asked you to provide the<\/p>\n<p>formulas that will drive the initial quote.<\/p>\n<p>Instructions:<\/p>\n<p>Determine Rate: You need to provide a rate for each customer based on their credit score. Any user who<\/p>\n<p>has a score less than 600 should be denied.<\/p>\n<p>1. Open case_study1_data and save as case_study1_LastFirst (use your own<\/p>\n<p>Last and First name).<\/p>\n<p>IF Function \u2013 Use the IF Function to figure out if an applicant is eligible for a personal loan. Please review this tutorial: Excel IF Functions For Beginners for help.<\/p>\n<p>2. Display the Approval Form worksheet and create an IF statement in cell I3 to<\/p>\n<p>determine if the applicant is eligible for a personal loan. Use the criteria below as<\/p>\n<p>part of your logic statement:<\/p>\n<p>\uf0b7 Credit Score &lt; 600 = \u201cDenied\u201d<\/p>\n<p>\uf0b7 Credit Score &gt;= 600 = \u201cApproved<\/p>\n<p>3. Copy using the Fill Handle the IF statement in cell I3 to into the Range I4:I10.<\/p>\n<p>VLOOKUP Function \u2013 Use the VLOOKUP Function to determine the rate of for those<\/p>\n<p>customers that were approved based on their credit scores. Please review this tutorial:<\/p>\n<p>VLOOKUP Functions for Beginners for help.<\/p>\n<p>4. Create a VLOOKUP function in cell J3 that uses the Credit Score in cell F3 to<\/p>\n<p>generate a rate based on the array in cells N4:O10. NOTE \u2013 Make sure to use<\/p>\n<p>the correct cell referencing.<\/p>\n<p>5. Copy using the Fill Handle the VLOOKUP statement in cell J3 to into the Range<\/p>\n<p>J4:J10.<\/p>\n<p>6. Delete out any Rate value for those customers that were denied.<\/p>\n<p><iframe loading=\"lazy\" title=\"Excel IF Functions For Beginners\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/JBypm1yjgLw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\n<iframe loading=\"lazy\" title=\"Vlookup Function in Excel for Beginners\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/Lw03WcG4mt4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\nCopyright 2022 Post University, ALL RIGHTS RESERVED<\/p>\n<p>Calculate Payment:<\/p>\n<p>PMT Function \u2013 Use the PMT Function to calculate the payment. Remember that the<\/p>\n<p>Yearly Periodic Rate is the Rate divided by the number of Months. Please review this<\/p>\n<p>tutorial: Excel PMT() Function Basics for help.<\/p>\n<p>You will calculate the payment quote for each customer.<\/p>\n<p>7. Calculate the periodic rate of the loan in cell K3.<\/p>\n<p>8. Copy using the Fill Handle the Periodic Rate in cell K3 to into the Range<\/p>\n<p>K4:K10.<\/p>\n<p>9. Delete out any Rate value for those customers that were denied.<\/p>\n<p>10. Use the PMT Function in cell L3 to calculate the payment. Make sure to return a<\/p>\n<p>positive value.<\/p>\n<p>11. Copy using the Fill Handle the Payment in cell L3 to into the Range L4:L10.<\/p>\n<p>12. Delete out any Rate value for those customers that were denied.<\/p>\n<p>Determine Maturity Dates: 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 the accounts maturity dates.<\/p>\n<p>13. Display the Existing Accounts worksheet and calculate the number of days<\/p>\n<p>remaining for each existing account based on today\u2019s date. You will need to use<\/p>\n<p>the Today() Function in your calculations.<\/p>\n<p>14. Calculate the maximum number of Days Remaining for all existing accounts in<\/p>\n<p>cell C17.<\/p>\n<p>15. Calculate the minimum number of Days Remaining for all existing accounts in<\/p>\n<p>cell C18.<\/p>\n<p>16. Calculate the average number of Days Remaining for all existing accounts in cell<\/p>\n<p>C19.<\/p>\n<p>17. Save and close the file.<\/p>\n<p>Requirements:<\/p>\n<p>\uf0b7 Submit the completed case_study1_LastFirst Excel file.<\/p>\n<p>Be sure to read the criteria below by which your work will be evaluated before you write and again after you write.<\/p>\n<p><iframe loading=\"lazy\" title=\"Excel PMT() Function Basics\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/yoqXEkuPSAs?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\nCopyright 2022 Post University, ALL RIGHTS RESERVED<\/p>\n<p>Assessment Rubric for Case Study 1 Assignment<\/p>\n<p>CRITERIA POINTS<\/p>\n<p>Save as case_study1_ LastFirstName 3<\/p>\n<p>Add logical statement the evaluates if the credit score is over 600 in cell I3. If so, return Approved, else return Denied.<\/p>\n<p>15<\/p>\n<p>Filled range I4:I10 and deleted out customers Denied. 5<\/p>\n<p>Use a VLOOKUP in cell J3 to determine the rate based on cell F3. 10<\/p>\n<p>Filled range J4:J10 and deleted out customers Denied. 5<\/p>\n<p>Calculate the Periodic Rate in cell K3. 10<\/p>\n<p>Filled range K4:K10 and deleted out customers Denied. 5<\/p>\n<p>Calculate the Loan Payment in cell L3. 10<\/p>\n<p>Filled range L4:L10 and deleted out customers Denied. 5<\/p>\n<p>Calculate the number of days remaining on each existing loan. 8<\/p>\n<p>Calculate the maximum number of days remaining on Existing Accounts.<\/p>\n<p>8<\/p>\n<p>Calculate the minimum number of days remaining on Existing Accounts.<\/p>\n<p>8<\/p>\n<p>Calculate the average number of days remaining on Existing Accounts.<\/p>\n<p>CIS250 \u2013 Excel Advanced<\/p>\n<p>The First Case Study<\/p>\n<p>ALL RIGHTS RESERVED 2022 Post University Copyright<\/p>\n<p>Unit 2&#8217;s due date is Sunday at 11:59 p.m. EST.<\/p>\n<p>100 points<\/p>\n<p>Overview:<\/p>\n<p>You&#8217;ve been given the duty of creating a loan approval booklet for this case study.<\/p>\n<p>will determine if an applicant is eligible for a personal loan and if so, what the loan rate<\/p>\n<p>should be based on a set of pre-defined criteria. The bank manager has created the<\/p>\n<p>basic layout of the application she wants to use but has asked you to provide the<\/p>\n<p>formulas that will drive the initial quote.<\/p>\n<p>Instructions:<\/p>\n<p>Determine Rate: You need to provide a rate for each customer based on their credit score. Any user who<\/p>\n<p>has a score less than 600 should be denied<\/p>\n<p>8<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CIS250 \u2013 Advanced Excel Case Study 1 Copyright 2022 Post University, ALL RIGHTS RESERVED Due Date: 11:59 pm EST Sunday of Unit 2 Points: 100\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7643,7642,7645,7644],"tags":[7678,8989,8988,7387,633,8991,630,8987,8994,8467,15,8990,7656,7571,8993,66,8992],"class_list":["post-104269","post","type-post","status-publish","format-standard","hentry","category-custom-same-day-essays","category-custom-writings-writers","category-do-my-essay-mla-format","category-write-my-paper-hub-writers","tag-best-custom-paper-writing-service","tag-best-online-paper-writing-service","tag-best-paper-writing-service","tag-best-research-paper-writing-services","tag-cheap-research-paper-writing-service","tag-cheapest-paper-writing-service","tag-college-paper-writing-service","tag-free-paper-writing-service","tag-free-term-paper-writing-service","tag-paper-writing-service","tag-paper-writing-service-reddit","tag-professional-paper-writing-service","tag-someone-to-write-my-paper","tag-websites-that-write-papers-for-you","tag-what-is-the-best-paper-writing-service","tag-write-my-paper","tag-write-my-paper-for-me-free"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/104269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=104269"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/104269\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=104269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=104269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=104269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}