Please show me how to get the answers using excel formulas.

for the terminal cash flow it says: Use the FV function and reference cells in the Problem area in order to obtain the amounts for Rate, Nper, and Pmt$.$

Function: FV; Cell reference.

Use the FV function, cell referencing the amounts for the Rate, Nper, and Pmt from the Problem area.

For the MIRR section it says: Use the Rate function and reference cells in the Problem area in order to obtain the amounts for the Nper and PV and a cell in the Student Work area in order to obtain the amount for FV

Function: Rate; Cell reference.

Use the Rate function, cell referencing the amounts for the Nper and PV from the Problem area and the FV from the Student Work area.