If you need to use data located in one workbook in the other workbook you have to create a(n)____ between the two workbooks.
A)anchor
B)source
C)link
D)index

Question

Quizplus · Accepted Answer

To use data from one workbook in another workbook, we need to create a link between the two workbooks. This can be done by using the 'Paste Link' option or by directly typing the formula with the reference to the source workbook. The other three options - anchor, source, and index - do not apply to this scenario.

If You Need to Use Data Located in One Workbook