Microsoft Excel 2021365 - Beginner to Advanced - Using the AGGREGATE Function

The video tutorial explains the use of the aggregate function in spreadsheets, which allows users to perform calculations like sum, average, count, min, and max while ignoring errors, hidden rows, and subtotals. It demonstrates how to use the function through examples, showing how to sum values while ignoring errors and count items while ignoring hidden rows.

What is one of the main uses of the aggregate function?

• To format cells

• To perform calculations while ignoring errors

• To sort data

• To create charts

Where can you find the aggregate function in the functions library?

• Under the Data tab

• Under the Insert tab

• Under the Math and Trig group

• Under the Home tab

In the example of summing prices, what option is used to ignore division errors?

• Option #3

• Option #6

• Option #9

• Option #7

What is the function number for performing a sum using the aggregate function?

• #3

• #2

• #6

• #9

When counting items with the aggregate function, which option ignores hidden rows and errors?

• Option #9

• Option #1

• Option #5

• Option #7