bunfetti
contestada

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

Which formulas inserted into column D would calculate the gain or loss of each fund and locate the fund with the largest gain C2B2 C3B3 C4B4 C5B5 MAXD2D5 C2B2 C class=

Respuesta :

CPED

Answer:

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

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.

Otras preguntas