accounting system. They want to evaluate sa time invoices have been outstanding. You will commissions and the length of 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 Invaice Data.

In the Inyoice 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 sales rep.

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 $Nbc$ 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.

Page $1$ of $2$

$396$ words

Focus

$100\%$