I need help with excel here is the problems I got wrong I-5 Insert a nested lookup function in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 5.000 A nested lookup function was not inserted in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 0.000/5.000 I-7 Perform an advanced filter based on the criteria range. Filter the existing database in place. 10.000 An advanced filter based on the criteria range was not performed. 0.000/10.000 I-8 In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel. 3.000 A database function was not entered to calculate the number of apartments to remodel in cell C7. 0.000/3.000 I-9 In cell C8, enter a database function to calculate the total lost rent for the month. 2.000 A database function was not entered to calculate the value of lost rent in cell C8. 0.000/2.000 I-10 Enter a database function to calculate the year of the oldest remodel in cell C9. 2.000
A database function was not entered to calculate the year of the oldest remodel in cell C9. 0.000/2.000 I-13 Insert a formula in cell E3 to calculate the total number of periods. 2.000 In the cell [E3] on Sheet (Loan), the 'Formula' was not set to 'B4*B5'. 0.000/2.000 I-16 In cell E6, insert a function to calculate the total interest paid on the loan. Ensure that the function returns a positive value. 2.000 A function in cell E6 was not inserted to calculate the total interest paid on the loan. 0.000/2.000 I-17 Complete the loan amortization table for the first five payments only.
In cell A11, enter 1. In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. Use the DATE function to complete the Payment Date column and financial functions for the Interest Paid and Principal Payment columns. In cell F11, enter =C11-E11. In cell C12, create a relative reference to cell F11. Note: Be sure to only complete the table through row 15. 18.000 Row [11] that starts with "1" was not detected in the submission. Engine reported the failure as ‘The loan amortization table was not completed for the first five payments only.' 0.000/5.400 Row [15] that starts with "5" was not detected in the submission. Engine reported the failure as ‘The loan amortization table was not completed for the first five payments only.' 0.000/1.800 Row [11] that starts with "1" was not detected in the submission.
Engine reported the failure as ‘Financial functions were not used for the Interest Paid columns.' 0.000/3.600 Row [11] that starts with "1" was not detected in the submission. Engine reported the failure as ‘Financial functions were not used for the Principal Payment columns.' 0.000/3.600 Row [12] that starts with "2" was not detected in the submission. Engine reported the failure as ‘A date function was not used for the Payment Date column.' 0.000/3.600 I-18 Create a footer with the sheet name code in the center, and the file name code on the right side of each worksheet. 6.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Summary worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission.
Engine reported the failure as ‘A footer with the file name code on the right side of Summary worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Database worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the file name code on the right side of Database worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Loan worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the file name code on the right side of Loan worksheet was not created.'