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.

Question

Quizplus · Accepted Answer

Before using the Subtotal feature, Dante must sort the data in the Product Type column to group all the entries for each product type together. This will ensure that subtotals are calculated accurately for each product type.

Dante Uses a Worksheet to List Sales Data from Five