Microsoft Exam 77-727 Topic 6 Question 33 Discussion

Actual exam question for Microsoft's exam

Question #: 33
Topic #: 6

[All Questions]

SIMULATION

Project 4 of 7: Car Inventory

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.

A1. 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 * 98%''.
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,.
4. Verify that the cell references in the formula are as desired.

B1. 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.

Show Suggested Answer

Suggested Answer: A

References:

https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/

by Nelida at Sep 22, 2022, 02:20 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!