ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 77-888 All Questions

View all questions & answers for the 77-888 exam
Go to Exam

Exam 77-888 topic 1 question 25 discussion

Actual exam question from Microsoft's 77-888
Question #: 25
Topic #: 1
[All 77-888 Questions]

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:

You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell. Which of the following formulas will you insert to accomplish the task?

  • A. =&B&3/100 * E8
  • B. =B3/100 * E8
  • C. =B3/100 * &E&8
  • D. =$B$3/100 * E8
  • E. =B3/100 * $E$8
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
In order to accomplish the task, you will have to insert the following formula:
=$B$3/100 * E8
According to the question, the formula will be inserted in cell F8 and then the cell's border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute reference. For this you will have to type currency symbol ($) before the row name and column number. In order to accomplish the task, type the following formula in the cell F8:
=$B$3/100 * E8
When absolute reference is used for referencing a cell in a formula, dragging cell's border to another cell does not change the cell's reference.
Answer options B and E are incorrect. This formula references the B3 cell as a relative reference.
After inserting the formula, when the cell's border is dragged, it will change the cell reference relatively.
Answer options A and C are incorrect. Ampersand symbol (&) is not used for referencing cells in Excel.
by Shahid_416 at Nov. 22, 2023, 11:49 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Shahid_416
1 year, 7 months ago
Correct Answer: D
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel