Question

How do you relate data in Excel?
​

Answer 1

Answer:

Creating a relationship in Excel – Step by Step tutorial

First set up your data as tables. To create a table, select any cell in range and press CTRL+T. ...

Now, go to data ribbon & click on relationships button.

Click New to create a new relationship.

Select Source table & column name. ...

Add more relationships as needed.

Explanation:

please follow and brainliest

Answer 2

Answer:

First set up your data as tables. To create a table, select any cell in range and press CTRL+T. ...

Now, go to data ribbon & click on relationships button.

Click New to create a new relationship.

Select Source table & column name. ...

Add more relationships as needed.