7. Which of the following statements regarding the Undo button is correct? The Undo button can only undo the most recent adjustment of the active worksheet. The Undo button can undo as many adjustments as you want, including those made before the worksheet was last saved. Ctrl+Z is the hotkey for the Undo button Ctrl+Z can bring up the drop-down list from the Undo button. If we need to frequently change more than three values of a model to see how the outputs change, what is the most efficient way? Delete the original values and enter the new values. Create multiple two-way tables for different combinations of input variables. Put spinner buttons in the cells for the input variables. Use the toggle tunction in Excel. 9. Orange Inc. is planning for a new product, the sales of which can be significantly affected by economic conditions. Kate is in charge of using spreadsheet modeling to evaluate this plan. Some of the factors that Kate is considering are production costs, price, economic conditions, and total profit . Which of the factors are inputs, and which of the factors are outputs? Input: production costs, price: Output: economic conditions, total profit. Input: production costs: Output: economic conditions, total profit, price, Input: production costs, economic conditions, total profit; Output: price. Input: production costs, economic conditions, price; Output: total profit. 10. See the screenshot below. Which of the following functions would calculate Tom's total earnings? 1 2 3 4 5 Earnings 12.00 10.00 5.00 12.00 5.00 14.00 11.00 5.00 13.00 10.00 13.00 B Name Mary $ Tom $ Jenny S Mary $ Bob $ Rachel S Cindy $ Saul $ Bob S Tom $ Jenny $ 6 7 8 9 10 11 12 13 000 =SUMIF(Earnings Name,"Tom") =SUMIF(Name Earnings, Tom) =SUMIF(Name "Tom", Earnings) SUMIF(NAME,Earnings, Tom)