Question

Before performing a subtotal, you must first sort the field which you want to have your subtotals based on.

A) False
B) True
C) Only for large datasets
D) Depends on software version

Answer 1

Before performing a subtotal, you must first sort the field on which you want to base your subtotals. This ensures accurate grouping and calculation.

Step-by-step explanation:

Before performing a subtotal, you must first sort the field on which you want to base your subtotals. This is because subtotals are calculated for each unique value in the sorted field. When the field is not sorted, the subtotals will not be accurate as they won't be grouped correctly.

For example, let's say you have a table of sales data with a 'Product' field and a 'Sales' field. If you want to get subtotals for each product, you need to sort the table by the 'Product' field first. This will ensure that the subtotals are calculated correctly for each product.