Final answer:
To insert subtotals for each category in the Rating field, the Subtotal function with the Sum operation is used, and the result is sorted from Largest to Smallest. The correct option is D,
Step-by-step explanation:
To insert subtotals for each category in the Rating field using the Sum function, and sort the result from Largest to Smallest, you would use the Subtotal function with the Sum operation (found typically under Data tools in spreadsheet software). You need to ensure that your data is grouped by the Rating field. Once this is done, for each group, the Subtotal function will add up the values present in the 2020 Sales field, categorizing them based on the Rating field. After applying the Subtotals for each category, you can then apply a grand total to summarize the overall total sales.
If you also want to apply the Average function to the Rating field, select the Rating column, find the Average function in your spreadsheet tool, and apply it to the selected cells. For utilizing the Min function on the 2020 Sales field, again, select the 2020 Sales column and then apply the Min function, which will give you the smallest (minimum) value in that column. Lastly, to use the Sort function on the Rating field, select the Rating column and apply the Sort function, specifying the criterion from Largest to Smallest to organize the data accordingly.
Note: Make sure to check the layout of your spreadsheet when combining cells or applying functions, as it should meet the criteria of having expected values of at least five for each combined cell, if necessary. It is important that these steps are followed in order to properly calculate and display the accurate subtotals, averages, minimums and organize the data thoroughly.