Page 20 - Computer - 8

7. Select a desired theme from the gallery.

Excel changes the colour scheme of the data table.

DISPLAYING SUBTOTALS
You can automatically calculate subtotals and grand totals in a list of data for a column by using the
Subtotal command.

Subtotals are not supported in Excel tables. Thus, you need to convert an Excel table into a normal list
of data before you apply subtotals to it. If the workbook is set to automatically calculate formulas, the
Subtotal command recalculates the subtotal and grand total values automatically as you edit the detail
data. The Subtotal command also outlines the list so that you can display and hide the detail rows for
each subtotal. You can choose the function to apply to subtotals and grand total values from one of the
functions – Sum, Count, Max, Min, Average, and Product.
Subtotals feature works best on data with column headings. The data in the range must be sorted on
one or more columns so that the grouping of values is done correctly.

To apply subtotals on a list of data in Excel:
1. Create the worksheet as shown in the image.

1 2

2. Sort the data on the basis of the column(s) you want to apply subtotals to.

Excel sorts the data accordingly.

18