For ease of use you would like for users to be able to...

For ease of use, you would like for users to be able to indicate the minimum loan amount on which they would like to pull loan information. You will do this by adding a parameter criterion to the LoanAmount field in the Customer Loans Parameter query. Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount (no period). The query should display all records that have a loan Amount that is greater than or equal to the value entered as the parameter. Run the query. Enter 250000 when prompted to Enter Minimum Loan Amount. You should have five results. Ensure that the query results display a total at the bottom of the Date column, and an average at the bottom of the Amount column. Save and close the query.

Transcript

00:01 Hello students, so here is the step by step instructions to accomplish the task you have mentioned in excel sheet as in step 1 is to approval from the worksheet approval from the worksheet worksheet as first is to first we need to display the approval from the worksheet and create the if statement in the cell in the cell b13 to determine if the if an applicant is eligible for the personal loan so you need to initially open the microsoft excel and create a new worksheet named as an a new worksheet new worksheet name as an approval name that worksheet as an approval form approval form fine in cell b in cell b9 enter the credit score for the applicant b9 enter the credit score of an applicant and in b and in b13 use the if statement to check if the credit score and the return approved or denied accordingly so they in and so enter the formula as i'll write under the formula in cell b13 as is equal to if if b9 is less than 600 then denied denied or approved it is a true false conditions applied in the if condition over here so where so where in this formula it checks it is score in a b9 is less than b600 if it is if it is that it returns a denied otherwise it returns approved so next as the first you'll create this create a new sheet then you will enter this formula this formula enter the all this of the formula fine whereas here the next is to create the create a vlookup vlookup function in cell b14 in cell b14 that uses the credit score in the cell b9 to generate the rate based on the array in the cell i4 and is to j11 so in cell i4 to j11 create a table that maps credit score responsible rate for example just create as i and j just create a table with the values of 600 5 .5 650 4 .8 and a 700 4 .2 and so on just go on creating the i and j values for it then later and make a note that the credit score should be an ascending order in a b14 cell so use the lookup function to find the rate based on this create so for…

Question

Please give Ace some feedback