D . At the beginning of the Year, FISH LAIDS ELECTRONICS MAKES & BULK Order Of CASES for each system they sell . Cyril wishes to show his sales associate a snap - shot of the number of cases that were ordered , sold , and are available at the warehouse for each Fish Chip system . Cyril already sorted the table containing this data , he just needs to insert subtotals into the table . Switch to the Cases Subtotal worksheet . Convert the Cases Subtotal table ( in the range A 1 : 124) into a range