You are responsible for tracking daily sales. The table below lists a few of transactions for your company. Notice that the sales tax amount and transaction totals are not filled in$.$ Complete the tasks to the right to complete the table.

Task # Points Task Description

$17$ Construct a formula in cell D$11$ to calculate the sales tax amount for transaction $578.$ Be sure to appropriately reference the transaction amount in cell C$11$ and the sales tax rate in cell C$8$ so that your formula can be reused for the remaining transations.

$21$ Copy the formula you used in cell D$11$ down to calculate the sales tax amount for the remaining transactions.

$36$ Construct a formula in cell E$11$ to calculate the total amount for transaction $578.$ Be sure to appropriately reference the transaction amount in cell C$11$ and the sales tax amount in cell D$11$ so that you can reuse your formula to calculate the total for the remaining transactions.

$42$ Copy the formula you used in cell E$11$ down to calculate the total for the remaining transactions.

$54$ Use the SUM function to calculate the "Grand Total" in for all transactions in cell E$24.$

Total: $20$

Statistics

There are $30$ Major League Baselball $($MLB$)$ teams. The table below lists the $2010$ and $1990$ payroll and win totals for each team $($notice that four teams were added after the $1990$ season$).$ Some MLB fans complain because the league does little to regulate the amount of money teams can pay for salaries. They argue that the teams that spend the most money will win the most games. This would put teams from small markets $($that earn less revenue$)$ at a disadvantage. Complete the $17$ tasks listed to the right. Insert your formulas $($or responses$)$ in column I for each task. Are small market teams at a disadvantage?

Task # Points Task Description

$15$ Use the COUNT function to calculate the number of MLB teams in $1990($range G$10$:G$39).$

$25$ Use the COUNTA function to calculate the number of MLB teams in $2010($use range F$10$:F$39).$

$35$ Use the SUM function to calculate the total amount of salaries paid in $1990.$

$45$ Use the SUM function to calculate the total amount of salaries paid in $2010.$

$55$ Use the AVERAGE function to calculate the average salary for the teams in $1990.$

$65$ Use the AVERAGE function to calculate the average salary for the teams in $2010.$

$75$ Use the MAX function to determine the maximum team salary amount in $1990.$

$85$ Use the MIN function to determine the minimum team salary amount in $2010.$