having trouble with excel functions, please help me with entering in interest. I can calculate the answers but the excel functions are incorrect

M E H Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulde. Question 3 On January 1, 2021 a Company acquired machinery and issued a noninterest bearing note: Face amount $825,000 Payable in 10 years Market interest rate 8% for similar borrowings Answer the following questions: 1) What are the total number of interest periods? 2) What is the market interest rate per semi-annual interest perod? 2 points 2 points 3) What is the face amount payable in 10 years? 2 points 4) Using the VLOOKUP function, identify the present value factor for the calculation of the present value of the face amount from the sheet 'PV of $1'. 2 points 5) Calculate the present value of the face amount at January 1, 2021, using the PV factor from (4) above 2 points Note: points will only be assigned where the answer is determine using EXCEL formule or cell references