The discount price is 95 percent of the price. Modify column J to show the discount price for each car.

Question

Explanation

Explanation/Reference:

1. In cell J10 on the "Car Inventory" worksheet enter "=G10*.95" Or "=G10 * 95%".
2. Copy the formula in cell J10 down to J40. (The formula needs to be copied down until all the cells the formula is required to be applied (J40).
3. Hold down the Ctrl key on your keyboard and press D which would "copy down" the formula for the rows below. OR
4. In cell J10 on the "Car Inventory" worksheet enter "=G10*.95" Or "=G10 * 95%".
5. Right-click on J10. From the mini toolbar, select Copy. OR click Copy from the Clipboard group situated on the Home tab.
6. Select cells J11 down to J40 (or the cells J11:J40). Right-click and from the mini toolbar, select Paste. OR click Paste from the Clipboard group situated on the Home tab, then click Paste Special and select Formulas. OR you could select Values for the formula results instead.
7. Check all the cell references in the formula are as desired. References: https://www.excelformulorum.com/excel-general/748491-calculate-discount-for-full-column.html https://support.office.com/en-us/article/insert-or-copy-a-formula-10640d0e-2c93-4a71-8710-b80fb0746bc0

No community discussion yet for this question.