90.2K

Verified Solution

Link Copied!

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 Formatting

Answer & Explanation Solved by verified expert

See Answer