a

Question 1 1 pts In the image below, what will be the result of clicking the AutoSum button? ee eee ae Home Insert Bey Page Layout Formulas 2 me Insert | AutoSum)Recently Financial Logical Text Date Lookup Math Functio : Used ~ i ~ Time Reference ~ Trig ~ Function Library BS / fe 56 A A B Cc D E FE 1 Inventory 2 3 January Febuary March 4 5 |Sheet Music 56 60 78 6 CDs 123 210 202 7 Pianos 3 4 3 8 Violins 7 5 6 9 Flutes 9 3 0 10 Guitars 3 2 6 11 Drums 4 6 4 Nothing will happen because there is no equals sign to begin the formula. The contents of cells B5, C5, and D5 will be added, and the result placed in cell E5. The Insert Function dialog box will open with the SUM function selected. The average of the contents of cells B5, C5, and D5 will be calculated, and the result placed in cell E5. Question 2 1 pts Which of the following can be used to create formulas that include functions? (Select all that apply.) C) Type the equal sign and then select the function from the drop-down menu that displays. (J Click the function displayed in the status bar at the bottom of the Excel window. () Click the Insert Function button on the Formulas tab to open the Insert Function dialog box (.) Click the Insert Function (fx) icon next to the formula bar to open the Insert Function dialog box