For subtotals to be useful and accurate, it is important that the data be correctly.
answer

-aligned

-formatted

-labeled

-sorted

The correct answer is letter "D": sorted.

Explanation:

In Microsoft Office Excel, subtotals are used to add numerical values from a list of data. Before applying a subtotal, the information must be sorted according to what is intended to be entered. This is the first step and one of the most important so the outcome of the subtotal will reflect correct and accurate information.

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok