I need step by step instructions for each excel question please.

$30.$ In the third scenario, Bao could pay back the loan for $5$ years with a monthly payment of $$20,000$ at an annual interest rate of $4\mathrm{.}55$ percent and then renegotiate better terms. He wants to know the amount remaining on the loan after $5$ years, or the future value of the loan.

In cell I$11,$ insert a formula using the FV function and the rate $($cell I$6),$ the number of periods $($cell I$8),$ and the monthly payment $($cell I$10)$ to calculate the future value of the loan for the $5$ Years scenario.

$31.$ Bao is also considering other properties to purchase. The worksheet should list information about these properties, which is contained in a webpage.

Import data from the webpage as follows:

a$.$ In the Expansion Funding worksheet, get data from the webpage Support$\_$EX$19\_$CS$4-7$a$\_$Properties.html$.($Hint: Use Windows Explorer to copy the path to the webpage, and then type $\backslash$Support$\_$EX$19\_$CS$4-7$a$\_$Properties.html at the end of the path.$)[$MAC Hint: Open the Support$\_$EX$19\_$CS$4-7$a$\_$Properties.html file in Excel.$]$

b$.$ Import only the Candidate Properties data. $[$MAC Hint: Copy the range A$1$:E$7$ from the Support$\_$EX$19\_$CS$4-7$a$\_$Properties.html file.$]$

c$.$ Load the webpage data as a table to cell F$26$ in the existing worksheet. $[$MAC Hint: Paste the range copied above into cell F$26$ of the Expansion Funding worksheet.$]$

d$.$ Format the imported data in the range F$26$ using Blue, Table Style Medium $2.[$MAC Hint: Format as Table using Blue, Table Style Medium $2.]$

$32.$ Bao wants to list the property information in the range F$15$:I$19$ using his preferred format.

Incorporate the imported data in the range F$15$:I$19$ as follows:

a$.$ In cell F$15,$ enter a formula using the PROPER function to capitalize the first letter in each word in the Type text in cell F$27.$

b$.$ Fill the range F$16$:F$19$ with the formula in cell F$15$ to list the remaining property types.

c$.$ In cell G$15,$ enter a formula using the CONCAT function that displays the first name shown in cell H$27$ followed by a space $(""),$ and then the last name shown in cell I$27.$

d$.$ Fill the range G$16$:G$19$ with the formula in cell G$15$ to list the full names of the remaining contacts.

e$.$ In cell H$15,$ enter a formula using the RIGHT function to insert the last $2$ characters on the right of cell G$27.$ Copy the formula in cell H$15$ to the range H$16$:H$19.$

f$.$ In cell I$15,$ enter a formula using the LEFT function to insert the first $2$ characters on the left of cell J$27.$ Copy the formula in cell I$15$ to the range I$16$:I$19.$

g$.$ Hide rows $26$ to $32$ so the worksheet does not display duplicated data.