Dante Uses a Worksheet to List Sales Data from Five

question 57

Multiple Choice

Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?

• A) Sort the data in the Product Type column.,
• B) Convert the range to a table.
• C) Outline the data.
• D) Remove calculated columns.

---

Definitions:

Collaborative Planning

A strategy where multiple stakeholders work together in the planning process to improve supply chain efficiency and meet shared goals.

CPFR

Collaborative Planning, Forecasting, and Replenishment, a business practice that combines the intelligence of multiple trading partners in the planning and fulfillment of customer demands.

Demand Management

The process of forecasting, planning, and managing the demand for products and services to optimize resources and ensure alignment with supply capabilities.

Safety Stocks

An inventory management method aimed at preventing stockouts by maintaining a predefined level of extra stock for products.