33. Which of the following Excel tools enables you to group and summarize information? a. Conditional Formatting b. Sorting c. Field lists d. PivotTable 34. When developing a Solver problem, you need t you need a. True b. False 35. Solver problems are limited to a single changing cell. a. True b. False 36. When you copy a formula a. Excel erases the original copy of the formula b. Excel edits cell references in the newly copied formula c. Excel adjusts absolute cell references d. Excel doesn't adjust relative cell references Casey's Monthiy Budget Question 37 figure 37. After working out her budget in above graph, Casey realizes that her expenses at $3,960 are far above her income of $2850. She wants to modify her budget by reducing all her non-essential budget items. Which analytical tool could she use to achieve this? a. Goal Seek ill allow her to change her total expenses by modifying all the cells she specifies which contain non-essential items. Data tables will allow her to change all the amounts to fit in with her income. b. e could use Solver to change her total expenses by modifying all the cells she specifies which contain non-essential items. She could use the PMT function to calculate her monthly budget payments and exclude non-essential items c. Sh d