Question

Your manager asks you to calculate the sale price if the product is marked down 20 percent. You enter the original price in cell A2. What formula should you use? =A2/80 =A2*80 =A2-.80 =A2*.80

Answer 1

Option =42*.80

Step-by-step explanation:

We can define a formula in Microsoft Excel using which is always started with "=" and then followed with the mathematical rule defined on the target columns or rows.

In this question, we are expected to calculate the marked down price for 20 percent. This means the new sale price will be 80% of the original sale price. Since the original place is in cell A2, we can define a formula using =A2* .80 to get the expected result.