Question

Which formulas inserted into column D would calculate the gain or loss of each fund and locate the fund with the largest gain?

=C2-B2, =C3-B3, =C4-B4, =C5-B5, =MAX(D2:D5)
=C2+B2, =C3+B3, =C4+B4, =C5+B5, =MAX(D5:D2)
=B2-C2, =B3-C3, =B4-C4, =B5-C5, =MAX(D2:D5)
none of the above

Answer 1

=B2-C2, =B3-C3, =B4-C4, B5-C5, = MAX(D2:D5)

Step-by-step explanation:

• When the entries of column C are subtracted from that of column B, it mean the current price is being deducted from the original price.
• We will get the loss or gain amounts.
• Prices will negative sign will indicate loss amount.
• Whereas positive figures will indicate gains.
• Now to locate largest gain, MAX function is used among the cells D2 to D5. It will return the largest gain value.