Which Excel Feature Is an Optimization Technique That Can Maximize

question 25

Multiple Choice

Which Excel feature is an optimization technique that can maximize or minimize a quantity given a set of limitations or constraints?

• A)Optimizer
• B)Goal Seek
• C)Analysis Tool-Pak
• D)Algorithm Builder
• E)Solver

---

Definitions:

Time-Driven

A method or approach that bases calculations, actions, or operations on the passage of time, often used in costing and scheduling.

Activity-Based Costing

A costing method that allocates overhead costs based on each product's activities or consumption rather than a standard rate.

Capacity Analysis

The act of determining the amount of production capability needed by an organization to meet its products' shifting demands.

Activity-Based Costing

An accounting technique that pinpoints activities within a company and allocates the expenses of each activity to every product and service based on their actual usage.