Answer:
the answer is A)Social Security tax: $2,194.80, Medicare tax: $513.30
Step-by-step explanation:
4. In cell-B8, create a formula without using a function that multiplies the value.in.cell.B7. by the value-in-cell-B6-andthen adds-the-value in B7..Update.the-cell-reference to cell: B6, from a relative reference to a mixed-reference by making an absolute-reference to row.6..Copy-the-formula-from-cell-B8-to-the-range-B9:B11-and-then-copy-the-formulas. from the range-B8:B11-to-the-range-C8:H11.1 13. SALO extend the list of years to the range A15:A17.1 In-cell-B13, create-a formula without a function using absolute references that subtracts the values of cells.B5 and B7.from.cell-B6 and then multiplies the result.by.cell-B8. Copy the formula-from-cell-B13 to the range C13:H13.1 In-cell-B14, create-a formula without using a function that adds.1.to the value-in-cell B12 and then multiplies the result by the value-in-cell-B13Update-the-referenceto-cell B12, from a relative-reference to a mixed-reference by making an absolute reference to row.12. Copy the formula-from-cell-B14-to-the-range-B15:B17 and then copy the formulas.from-the-range-B14:B17 to the range-C14H17.1
Solutions: x=1<span>. Hope its right :)</span>
