Consider the following Excel spreadsheet. Reference: Excer - rig 1 A correct formula to compute the revenue in cell D2 is A.=$B2$C2 B.=$B$2$C$2 C. =B2C2 D. All of the above Consider the following Excel spreadsheet. If formula =$B$2$C$2 is entered in cell D2 and the formula is copied down to cells to cell D3 and D4, the result in cells D2, D3, and D4 should be , respectively. A. 0,0,0 B. 60,60,60 C. 60,279,288 D. None of the above Consider the following Excel spreadsheet. If the formula =SUM(B2:B4) is entered in cell B5, and the formula is copies to cells C5 and D5, the result in cells B5, C5, and D5 should be _ _ respectively. A. 67,67,67 B. 67,26,627 C. 36,17,348 D. None of the above Reference: Break Even Analyuls Consider the spreasdheet model above. Which formula should be entered in Cell B7 to compute the break-even quantity A.=B4/B3B5B.=B3/(B4B5)C.=B4/(B5B3)D.=B4/(B3B5) Consider the spreadsheet model above. What information should be entered in Goal Seek to compute the break-even quantity A. Set cell: \$E\$7, To value: 0, By changing cell: $B$7 B. Set cell: $E$7, To value: 3250 , By changing cell: $B$7 C. Set cell: $B$7, To value: 0 , By changing cell: $E$3$E$6 D. Set cell: $8$7, To value: 0, By changing cell: \$E\$7 Referenoe: Break Even Analyss Consider the spreadsheet model above. What information should be entered in Cell E4 to calculate Annual Variable Cost? A=B5 B. =B5B7 C=B5+B7 D. =B3B7