Listen

Examine the attached worksheet. Which of the following formulas, when entered in cell B$11,$ will give the total Quantity$*$Price of all the items purchased?

Formulas$\_$Test.xIsx

All the other options are correct

$=$SUMPRODUCT$($B$2$:B$8,$C$2$:C$8)$

$=$ SUM$($D$2$:D$8)$

$=(D2+D3+D4+D5+D6+D7+D8)$