Where can you create a relationship between two Excel tables?
A) Power Pivot
B) Power View
C) Get & Transform window
D) Solver

Question

Quizplus · Accepted Answer

Power Pivot is a feature in Excel that allows users to create a data model by combining multiple tables of data. Within Power Pivot, users can establish relationships between tables using a common column in each table, which enables them to analyze and visualize the data more effectively. Power View and Get & Transform window are also useful features in Excel, but they are not specifically designed for creating relationships between tables. Solver is a tool in Excel for optimizing solutions to problems, and it does not allow users to create relationships between tables.

Where Can You Create a Relationship Between Two Excel Tables