Microsoft
77-427 · Question #3
77-427 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Question
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?
Options
- A=&B&3/100 * E8
- B=B3/100 * E8
- C=B3/100 * &E&8
- D=$B$3/100 * E8
- E=B3/100 * $E$8
Unlock 77-427 to see the answer
You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.