Science Technologies, Inc has downloaded some raw invoice material from their accounting system. They want to evaluate salesman commissions and the length of time invoices have been outstanding. You will complete the following worksheet analysis for them.

Open the Invoice Analysis files and complete the following:

Instructions:

You must use tables and named cells in this assignment!

In the cell $H1$ enter the date $\frac{6}{30}\frac{?}{2023}$ as the current date.

In the cell $K1$ enter $4\%$ as the commission rate.

Create a copy of the Invoices worksheet. Name the new worksheet Inyqice Data.

In the Invoice Data worksheet:

Insert a table named Invoices with at table style: None.

In the Inyoice Data worksheet, in the G column calculate the days past due. $($Current date $-$ invoice date$).$ Format number with $0$ decimal places.

In column D$,$ calculate the sales rep's commissions by multiplying the commission rate $*$ the invoice amount.

Add totals at the bottom of the Commissions and invoice amounts columns.

In the Invoice Analysis worksheet:

Format columns appropriately.

In the B column use a COUNTIF function to count the number of invoices for each sales rep. Your functions must contain table references.

In the Commission column, use a SUMIF to total the commissions for each salesrep.

In the Total Amount column, use a SUMIF to total the invoices for each sales rep.

Create totals at the bottom of each column and format appropriately. $($Hint: totals should equal the totals you created in the Invoices worksheet$)$

In the $Nbr$ Invoices column use COUNTIFS to count the invoices in eachaging category.

In the Amount column use SUMIFS to total the invoices in each aging category.

Create totals at the bottom of each column and format appropriately. $($Hint: totals should equal the totals you created in the Invoices worksheet and in the Sales Rep Analysis on the Invoice Analysis worksheet.

Add your $3-$line title to the Invoice Analysis Worksheet.