could you please help me? I am not sure how to do this in excel.

4. Name cells B3 through B8 using the "Create from Selection" function shown in class. If you missed class you will need to search Excel Help online for the use of this feature. 5. Format cells B3 through B8 appropriately (Accounting \$ for \$ amounts, percentage for rate, number for years) Use 2 decimal places for all except years 6. Use the "PMT" function in Excel to properly calculate the MONTHLY payment in Cell B8. Assume end of period payments and 4. Name cells B3 through B8 using the "Create from Selection" function shown in class. If you missed class you will need to search Excel Help online for the use of this feature. 5. Format cells B3 through B8 appropriately (Accounting \$ for \$ amounts, percentage for rate, number for years) Use 2 decimal places for all except years 6. Use the "PMT" function in Excel to properly calculate the MONTHLY payment in Cell B8. Assume end of period payments and