33. Which of the following Excel tools enables you to group and summarize inform

Question

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.

Explanation / Answer

Solution to Q33:

d. Pivot Table

Pivot Table saves you a lot of time by allowing you to quickly summarize large amounts of data into a meaningful report.

Solution to Q 34:

True.

Constraint provides bounds on decision variables. Hence, solver needs to properly take care of constraint conditions.

Solution to Q 35:

False.

Solver problems are not just limited to a single changing cell. Changing cell determines the number of decision variables which can be more than one in number.

Solution to Q 36:

b.  Excel edits cell references in the newly copied formula.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.