Question

This tool in Calc allows you to create a group of cells automatically and apply common functions like sum, average on the grouped data. It is known as ______ tool.

Options

• Sum

• Subtotal

• Function

• Common

Answer 1

This tool in Calc allows you to create a group of cells automatically and apply common functions like sum, average on the grouped data. It is known as Subtotal tool.

Explanation:

You can use the Subtotal tool in Calc to automatically group data by categories, then apply functions like SUM or AVERAGE to the grouped data. In this way, it is easier to quickly summarize big datasets.