Question 1 A Not yet saved N Marked out of 1.00 Flag question 1 Shopping Costs 2 Item Cost 3 Bananas $ 2.11 4 Apples $ 4.37 5 Carrots $ 1.90 6 Detergent $ 2.99 7 Granola $ 5.40 8 TOTAL Study the screenshot above. The total of all the shopping list costs should display in cell B8. Which of the following methods will NOT successfully give the total? Select one: a. Select cells B3:B7, press the AutoSum menu icon and then press enter. b. In cell B8 type the formula: =Sum(B3:B7) and press enter. C. In cell B8 type the formula: =B3:37 O d. Select cell B8, press the AutoSum menu icon and then press enter