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

1.1

Construct a formula in cell D5 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C5 and the sales tax rate in cell C2 so your formula can be reused for the remaining transactions.

1.2

Copy the formula you used in cell D5 down to calculate the sales tax amount for the remaining transactions.

1.3

Construct a formula in cell E5 to calculate the total amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C5 and the sales tax amount in cell D5 so you can reuse your formula to calculate the total for the remaining transactions.

1.4

Copy the formula you used in cell E5 down to calculate the total for the remaining transactions.

1.5

Use the SUM function to calculate the grand total for all the transactions in cell E18.

AutoSave OFF W H FC... Book3 Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments Insert v Calibri (Body) v 12 AA = ab v General ZY AP- O. me x Delete v V Z Conditional Format Cell Sort & Find & Analyze Tasks Create and Share Paste BIUV DVAv E E $ ~ % " Formatting as Table Styles Format v Filter Select Data Adobe PDF 026 fx D E F G H J K L M N 0 P Q A MyEducator Tasks Sales Tax Rate 6.75% appropriately reference the transaction amount in cell C5) and the sales tax Transaction ID Amount Sales Tax Total amount in cell D5 ) so you can reuse 578 $42.00 579 $167.00 your formula to calculate the total for 580 $209.00 the remaining transactions. 581 $142.00 582 $234.00 583 $88.00 584 $197.00 1.4 Copy the formula you used in ~ 12 585 $209.00 586 $163.00 cell E5) down to calculate the total for 14 587 $151.00 the remaining transactions. 15 588 $103.00 16 589 $148.00 2 2 590 $51.00 18 Grand Total 1.5 Use the SUM function to 19 20 calculate the grand total for all the transactions in cell E18) 25 26 27 2 Statistical Functions There are 30 Major League Baseball (MLB) teams. The table on the statistical functions worksheet lists the 2019 and 1990 payroll and win totals for each team (notice that four teams were 38 added after the 1990 season). Some 39 40 MLB fans complain because the league 41 does little to regulate the amount of D Statistical Functions Financial Functions Formulas + money teams can nav for salaries They + 100% Ready