Question 36: Which action uses cell references to perform a sensitivity analysis on an Excel worksheet? Answer: A. Changing the amount in a cell that is used in a formula elsewhere in the worksheet B. Deleting a row of worksheet data C. Creating a formula that solely contains numbers D. Replacing the formula in a cell with the result of that formula Question 6: Louisa is analyzing a large worksheet and needs to quickly review the sum, average, maximum, and minimum values for different ranges, What is the fastest way to accomplish this? Answer: A. 9 Customize the status bar to display oach of the required values. B. Create formulas and then use Copy and Paste for each range of values; C. Customize the status bar to display one required value and then repeat for each of the other required values: D. Q Create formulas and then modify those formulas for each range of values