Dove Corp provided you with the following information.

• Total sales for October amounted to $215,000.
• It is expected that bad debts will equal 5% of total sales in any given month.
• 30% of total sales are cash sales (paid for at the time of sale) and these customers obtain a 10% discount.
• The remaining sales are on credit terms of one month and the total of bad debts should be set against these receipts.

The money received for cash sales in October is expected to be:

a. $64,500

b. $55,147

c. none of the other answers are correct

d. $58,050

Why create an Excel table, prior to creating a PivotTable?

a. Because you won't have to refresh the table later when the PivotTable is updated.

b. Because if new rows or columns are added to the table, the PivotTable will not be aware of them when refreshed.

c. Because if new rows or columns are added to the table, the PivotTable will be aware of them when refreshed.

d. Because you won't have to refresh the PivotTable later to update it.

Dove Corp provided you with the following information.

• Total sales for October amounted to $215,000.
• It is expected that bad debts will equal 5% of total sales in any given month.
• 30% of total sales are cash sales (paid for at the time of sale) and these customers obtain a 10% discount.
• The remaining sales are on credit terms of one month and the total of bad debts should be set against these receipts.

The expected bad debts relating to October sales is:

a. $10,750

b. $3,225

c. $7,525

d. $6,450