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…

Question

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

• B
  7% (1)
• C
  7% (1)
• D
  73% (11)
• E
  13% (2)

Explanation

In order to accomplish the task, you will have to insert the following formula: 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: 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 Answer options A and C are incorrect. Ampersand symbol (&) is not used for referencing cells in

No community discussion yet for this question.