Question

Enter a formula in cell B2 to calculate Ken Dishner's bonus for the first quarter. Multiply his sales total (cell E8) times the bonus rate (the cell named bonus rate). Use the named range, not a cell reference. a) Ken Dishner's bonus = E8 * bonus rate b) Ken Dishner's bonus = B2 * E8 c) Bonus rate = E8 / B2 d) E8 = Ken Dishner's bonus * bonus rate

Answer 1

The correct formula to enter into cell B2 is Ken Dishner's bonus = E8 * bonus rate, where 'bonus rate' is a named range.

Step-by-step explanation:

To calculate Ken Dishner's bonus for the first quarter in cell B2, you should multiply Ken Dishner's sales total (cell E8) by the bonus rate, which is defined by a named range and not a direct cell reference. Therefore, the correct formula to enter into cell B2 would be:

Ken Dishner's bonus = E8 * bonus rate

This formula uses the value in cell E8 and multiplies it by the value associated with the named range 'bonus rate' to give the resulting bonus for Ken Dishner.