Home » Microsoft » 77-727 » SIMULATION
SIMULATION
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale.
The discount price is 95 percent of the price. Modify column J to show the discount price for each car.
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.
2. Select cell J10, hold the Shift key on your keyboard, and use the down arrow key 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
1. In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.
2. Select cell J10, then Right-click and select Copy, OR click Copy from the Clipboard group situated on the Home tab.
3. Paste the formula by selecting Paste from the Clipboard group situated on the Home tab, OR Right-click then 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.
4. Verify that the cell references in the formula are as desired.
References: https://www.excelforum.com/excel-general/745891-calculate-discount-for-full-column.html https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6
