I need help on these in excel. Please list in detail how to use these functions in Excel . I need help on the yellow and red boxes pleaseee!

A B C D E Sales Tax Rate 6.75% Transaction ID Amount Sales Tax Total 578 579 580 581 582 583 584 585 586 587 588 589 590 $42.00 $42.07 $84.07 $167.00 $167.07 $334.07 $209.00 $209.07 $418.07 $142.00 $142.07 $284.07 $234.00 $234.07 $468.07 $88.00 $88.07 $176.07 $197.00 $197.07 $394.07 $209.00 $209.07 $418.07 $163.00 $163.07 $326.07 $151.00 $151.07 $302.07 $103.00 $103.07 $206.07 $148.00 $148.07 $296.07 $51.00 $51.07 $102.07 $3,808.88 Grand Total F G H I J K L My Educator Tasks Task 1 Construct a formula in cell D5 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C5 and the sales tax rate in cell C2 so your formula can be reused for the remaining transactions. [-2] The value in cell D5 is not correct [-2] The formula in cell D5 does not reference the sales tax rate [-1] The formula in cell D5 does not contain an absolute reference to the tax rate [-2] The formula in cell D5 does not reference the transaction amount Task 2 0/1 points Copy the formula you used in cell D5 down to calculate the sales tax amount for the remaining transactions. [-1] The formulas in range D5:D17 are not reused Tack 2 6/6 points DUWIIIau WIKOUK 0/7 points A B C D Financial Functions Task 1 Data Loan Amount Interest Rate* Number of Payments Monthly Payment $860.89 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 3 and 4 Data Loan Amount Monthly Payment -$212,000.00 $950.00 360 Number of Payments Nominal Interest Rate 0.29% 4% Effective Interest Rate *Remember to multiply the nominal interest rate by 12 (to calculate the annual interest ratel Task 6-8 Data Loan Amount Interest Rate* Number of Payments Monthly Payment Total Daumante (DMT * # of DIATel Statistical Functions -$175,000.00 4.25% 360 0.003542 Interest Rate* E Task 2 Data Monthly Payment Number of Payments Loan Amount $243,932.24 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 5 Data Monthly Savings Amount Interest Rate* Number of Months 3.48% Future Account Balance 15 Year Mortgage 30 Year Mortgage -$310,000.00 4.50% -$310,000.00 4.50% 360 180 $2,371.48 $1,570.72 $176 966 96 $565 A60 011 Formulas Financial Functions F -$1,200.00 + G 4.25% 0.00354167 360 $2,811.15 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. 0.00375 -$75.00 2.75% 0.00229167 36 MyEducator Tasks Tapk 1 Tere points You are interested in purchasing a home. What will your monthly payment be if you take out a $175,000 mortgage for 30 years (360 months) at 4.25% interest? [-0.5] The formula in cell C10 does not divide the rate by 12 Task 2 4.5/5 points You are interested in purchasing a home. You can afford $1200 a month as a mortgage payment. How much can you pay for a home assuming a 30 year (360 months) loan at 4.25% interest? [-0.5] The formula in cell F10 does not divide the rate by 12 Task 3 3.5/5 points You are interested in purchasing a home. You have been quoted monthly payments of $950 for a 30 year mortgage. Your original loan amount is $212,000. What is the interest rate you will pay on the loan? [-0.5] The formula in cell C22 does not annualize the rate [-11 The value in cell C22 is not correct 167 167 Task 4 3/5 points What is the effective annual rate of the loan you worked with in task 3? [-2] The value in cell C23 is not correct Task 5 4.5/5 points You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money will you have in your savings account in 36 months for your trip? [-0.5] The function in cell F22 does not divide the rate by 12 Task 6 4.5/5 points You are interested in purchasing a home. You will take out a mortgage of $310,000 to pay for the home and pay 4.5% interest. What will your monthly payment be if you take 15 years to pay off the loan? [-0.5] The function in cell C36 does not divide the rate by 12 Task 7 4/5 points What will your monthly payment be if you take 30 years to pay off the loan you worked with in task 6? (Please reference the loan information in the "Task 6-8 Data" cells as the arguments for your functions.) [-0.5] The formula in cell D36 does not reference D33 [-0.5] The function in cell D36 does not divide the rate by 12 Task 8 5/5 points A B C D E Sales Tax Rate 6.75% Transaction ID Amount Sales Tax Total 578 579 580 581 582 583 584 585 586 587 588 589 590 $42.00 $42.07 $84.07 $167.00 $167.07 $334.07 $209.00 $209.07 $418.07 $142.00 $142.07 $284.07 $234.00 $234.07 $468.07 $88.00 $88.07 $176.07 $197.00 $197.07 $394.07 $209.00 $209.07 $418.07 $163.00 $163.07 $326.07 $151.00 $151.07 $302.07 $103.00 $103.07 $206.07 $148.00 $148.07 $296.07 $51.00 $51.07 $102.07 $3,808.88 Grand Total F G H I J K L My Educator Tasks Task 1 Construct a formula in cell D5 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C5 and the sales tax rate in cell C2 so your formula can be reused for the remaining transactions. [-2] The value in cell D5 is not correct [-2] The formula in cell D5 does not reference the sales tax rate [-1] The formula in cell D5 does not contain an absolute reference to the tax rate [-2] The formula in cell D5 does not reference the transaction amount Task 2 0/1 points Copy the formula you used in cell D5 down to calculate the sales tax amount for the remaining transactions. [-1] The formulas in range D5:D17 are not reused Tack 2 6/6 points DUWIIIau WIKOUK 0/7 points A B C D Financial Functions Task 1 Data Loan Amount Interest Rate* Number of Payments Monthly Payment $860.89 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 3 and 4 Data Loan Amount Monthly Payment -$212,000.00 $950.00 360 Number of Payments Nominal Interest Rate 0.29% 4% Effective Interest Rate *Remember to multiply the nominal interest rate by 12 (to calculate the annual interest ratel Task 6-8 Data Loan Amount Interest Rate* Number of Payments Monthly Payment Total Daumante (DMT * # of DIATel Statistical Functions -$175,000.00 4.25% 360 0.003542 Interest Rate* E Task 2 Data Monthly Payment Number of Payments Loan Amount $243,932.24 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 5 Data Monthly Savings Amount Interest Rate* Number of Months 3.48% Future Account Balance 15 Year Mortgage 30 Year Mortgage -$310,000.00 4.50% -$310,000.00 4.50% 360 180 $2,371.48 $1,570.72 $176 966 96 $565 A60 011 Formulas Financial Functions F -$1,200.00 + G 4.25% 0.00354167 360 $2,811.15 Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. 0.00375 -$75.00 2.75% 0.00229167 36 MyEducator Tasks Tapk 1 Tere points You are interested in purchasing a home. What will your monthly payment be if you take out a $175,000 mortgage for 30 years (360 months) at 4.25% interest? [-0.5] The formula in cell C10 does not divide the rate by 12 Task 2 4.5/5 points You are interested in purchasing a home. You can afford $1200 a month as a mortgage payment. How much can you pay for a home assuming a 30 year (360 months) loan at 4.25% interest? [-0.5] The formula in cell F10 does not divide the rate by 12 Task 3 3.5/5 points You are interested in purchasing a home. You have been quoted monthly payments of $950 for a 30 year mortgage. Your original loan amount is $212,000. What is the interest rate you will pay on the loan? [-0.5] The formula in cell C22 does not annualize the rate [-11 The value in cell C22 is not correct 167 167 Task 4 3/5 points What is the effective annual rate of the loan you worked with in task 3? [-2] The value in cell C23 is not correct Task 5 4.5/5 points You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money will you have in your savings account in 36 months for your trip? [-0.5] The function in cell F22 does not divide the rate by 12 Task 6 4.5/5 points You are interested in purchasing a home. You will take out a mortgage of $310,000 to pay for the home and pay 4.5% interest. What will your monthly payment be if you take 15 years to pay off the loan? [-0.5] The function in cell C36 does not divide the rate by 12 Task 7 4/5 points What will your monthly payment be if you take 30 years to pay off the loan you worked with in task 6? (Please reference the loan information in the "Task 6-8 Data" cells as the arguments for your functions.) [-0.5] The formula in cell D36 does not reference D33 [-0.5] The function in cell D36 does not divide the rate by 12 Task 8 5/5 points