contestada

if you create a recommended pivottable on a group of data about book sales with these columns: discipline (i.e. business), area (i.e. finance and marketing), units sold, wholesale price, what column might excel use as values? a) discipline b) area c) units sold d) both discipline and area

Respuesta :

If a pivot table is created on a group of data about book sales with these columns: discipline (i.e. business), area (i.e. finance and marketing), units sold, wholesale price, The column might excel use as values of d) both discipline and area.

What is a pivot table?

Pivot tables are an incredibly powerful tool for data analysis and visualization. They allow you to quickly and easily summarize large amounts of data into meaningful information. Pivot tables can be used to compare and analyze data from multiple different sources and to identify trends and patterns in data. They are especially useful when dealing with large datasets, where manual analysis would be too time-consuming or difficult. Pivot tables are also incredibly versatile, allowing you to customize the display of the data to meet your specific needs.

The pivot table will use values from both the discipline and area columns to calculate the total units sold and wholesale price for each discipline and area combination. This will allow the user to compare the sales and prices of different books in different areas of the business, such as finance and marketing.

It can be concluded that if a pivot table is created on a group of data about book sales with these columns: discipline (i.e. business), area (i.e. finance and marketing), units sold, wholesale price, what column might excel use as values of d) both discipline and area.

To know more about pivot table, check this link:

https://brainly.com/question/29786913

#SPJ4