Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE SHOW ME THE FORMULAS TO DO THIS c. Click cell D5, ensure the Formulas tab is displayed, click Logical in the Function Library group,
PLEASE SHOW ME THE FORMULAS TO DO THIS
c. Click cell D5, ensure the Formulas tab is displayed, click Logical in the Function Library group, and select IF. d. Type C5OK. This uses the IF function to calculate the required down payment based on credit score. If the customer has a credit score higher than 750 a down payment is not required. All clients with credits scores lower than 750 must pay a required 10% down payment in advance. e. Double-click the fill handle to copy the contents of cell D5 down the column, click Auto Fill Options to the lower-right of the copied cells, and then select Fill Without Formatting to ensure that the Bottom Double border remains applied to cell D10. f. Calculate the Amount Financed by doing the following: - Click cell E5 and type =B5-D5. - Use cell E5's fill handle to copy the function down the column. - Apply Bottom Double border to cell E10. g. Calculate the Rate by doing the following: - Click cell F5. Click Lookup \& Reference in the Function Library group on the Formula tab, and select VLOOKUP. - Type C5 in the Lookup_value box, type \$A\$14:\$B\$19 in the Table_array box, type 2 in the Col_index_num box, and then click OK. - Double-click cell F5's fill handle to copy the function down the column. - Click Auto Fill Options, and select Fill Without FormattingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started