Question

Microsoft Excel is installing in your Laptop, it uses ____ function while creating a data table.​

Answer 1

Answer:

Microsoft Excel is installing in your Laptop, it uses Table function while creating a data table

Answer 2

Answer:

While creating a data table, aggregate functions are used.

Explanation:

A pivot or data table is actually a summary of the big data set where it includes average, minimum, maximum, etc. For example, we can consider the sales data. The sales data can be summarized as a pivot table as average sales per region, minimum and maximum sales per region, etc.

So, to analyze and to summarize this data table, aggregate functions are utilized. The aggregate functions are SUM, MAXIMUM, MINIMUM, AVERAGE, etc. Then the charts are created subsequently and can be altered by altering using aggregate functions.