Question

Which function cannot be performed through Subtotal in a Spreadsheet?
a)sum b) Average c) product d) percentage

Answer 1

Answer:

What is the SUBTOTAL Function in Excel?

The SUBTOTAL function in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided.

 

Formula

SUBTOTAL = (method, range1, [range2 …range_n])

Where method is the type of subtotal you wish to obtain

Range1,range2…range_n is the range of cells you wish to subtotal

 

Why do we need to use SUBTOTALS?

Sometimes, we need data based on different categories. SUBTOTALS help us to get the totals of several columns of data broken down into various categories.

For example, let’s consider garment products of different sizes manufactured. The SUBTOTAL function will help you to get a count of different sizes in your warehouse.

To learn more, launch our free Excel crash course now!

 

How to use the SUBTOTAL Function in Excel?

There are two steps to follow when we wish to use the SUBTOTAL function. These are:

Formatting and sorting of the provided Excel data.

Applying SUBTOTAL to the table.

 

Let’s understand this Excel function with the help of an example. We use data provided by a garment manufacturer. He manufactures T-shirts of five different colors, i.e., White, Black, Pink, Green, and Beige. He produces these T-shirts in seven different sizes, i.e. 2, 4, 6, 8, 10, 12, 14. The relevant data are below:

Explanation:

Image \/

https://cdn.corporatefinanceinstitute.com/assets/subtotal-function1-467x1024.png

Answer 2

(d). The SUBTOTAL function in Excel allows users to create groups and then perform various other Excel functions such as sum, count, average, product, Max.

Explanation:

• Subtotal is a function listed under the Mathematical category when you use the Function Wizard (Insert & Function).
• The Subtotal function allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX.
• The Subtotal function in Excel allows users to construct groups and then use SUM, COUNT, AVERAGE, PRODUCT, MAX, and other Excel functions on them.
• As a result, the Excels SUBTOTAL tool aids in the analysis of the data. Excel's SUBTOTAL tool aids in the analysis of the data.