Question

Taxes reduce your paycheck by 22% each month. In an Excel spreadsheet, the salary earned for a month stored in cell A35. Write an Excel formula that would calculate the dollar amount of taxes.

a.
=A35*1.22

b.
=A35/0.22

c.
=A35*0.22

d.
=0.22/A35

e.
=A35/22

f.
None of the above.

Answer 1

Answer: Option 'c' is correct.

Explanation:

Since we have given that

The salary earned for a month stored in = A35

Rate of tax reduces by = 22%

We need to remove the % sign by dividing 22 by 100 and it becomes 0.22.

So, the dollar amount of taxes is given by

`Taxes=A35* (22)/(100)\\\\Taxes=A35* 0.22`

Hence, Option 'c' is correct.