Complete three columns on the Data worksheet: Days to payment, Gross profit $-$ sale date, and Cash received $-$ payment date.

R$1.$ Cell J$2$: Enter a formula that results in the number of days between the invoice date and the payment date using the data in row $2.$

R$2.$ Cell K$2$: Enter a formula that results in gross profit on the invoice date using the data in row $2.$

$

R$3.$ Cell L$2$: Enter a formula that results in the amount of cash the customer pays using the data in row $2.$

Assume the customer takes the discount if they pay in $10$ or fewer days after the invoice date.

$

R$4.$ Copy down the entries in cells $J2,K2,$ and $L2$ to all other rows with data.

Steps to create a pivot table:

S$1.$ Select a cell in the data on the Data worksheet.

S$2.$ Select Insert $/$ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear.

table and select "Show Field List".$)$

Questions:

Use the information on the Data worksheet and pivot tables, formulas, and$/$or functions to answer the following questions.

Q$1.$ What is the amount of gross profit on the sale date in June, July, and August for customers Fresno, Lisbon, and Trondheim combined?