To add a total row to the table, which steps would you perform?

To add a total row to the table, which steps would you perform?

• A. Home tab, Styles group, Format as Table
• B. Table Design tab, Table Style Options group, click Total Row
• C. Data tab, Sort & Filter group, A to Z
• D. Insert tab, Tables group, PivotTable

Answer: (B)

Adding a total row is a feature you enable from the table’s design options. To display the total row, you need to open the Table Design tab and use the Table Style Options group, then click Total Row. This turns on a bottom row in the table where Excel can automatically compute aggregates (like sum, average, etc.) for each numeric column, and you can choose the function for each column as needed. The other actions don’t produce a total row by themselves: formatting as a table creates the table but doesn’t show a total row until you enable it; sorting or filtering won’t add a total row, and inserting a PivotTable is for summarizing data in a different object entirely.

Adding a total row is a feature you enable from the table’s design options. To display the total row, you need to open the Table Design tab and use the Table Style Options group, then click Total Row. This turns on a bottom row in the table where Excel can automatically compute aggregates (like sum, average, etc.) for each numeric column, and you can choose the function for each column as needed.

The other actions don’t produce a total row by themselves: formatting as a table creates the table but doesn’t show a total row until you enable it; sorting or filtering won’t add a total row, and inserting a PivotTable is for summarizing data in a different object entirely.