please answer all questions

Determining amounts to be paid on invoices Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period: This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Round your answers to the nearest dollar. The data of each of the invoices are provided in the table below. Assume that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Calculate the corresponding amount for each of the cases below. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (L7:L11) into the appropriate fields in CNOWv2 for grading