Can a pivot table use multiple sources of data?



Can a pivot table use multiple sources of data?..

Answer / Yasir Moheet

Yes, a Pivot Table in Excel can combine and analyze data from multiple tables or ranges. This is done by linking the tables using a common field called the 'PivotTable Relationship'. Each table acts as a separate source of data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you remove a page background in a worksheet?

1 Answers  


Can you do multiple if then statements in excel?

1 Answers  


What is ms excel and its advantages?

1 Answers  


What Is Your Process For Creating A Dashboard?

1 Answers   Microsoft,


What is range in excel sheet?

1 Answers  


How can you wrap the text within a cell?

1 Answers  


What is the concatenate formula in excel?

1 Answers  


How do you create a filter in excel?

1 Answers  


How do you make a table not a table in excel?

1 Answers  


What is spreadsheet formula?

1 Answers  


How do you make a div 0 0?

1 Answers  


What is a table array in excel?

1 Answers  


Categories