When referencing data in another workbook, what must you use?

When referencing data in another workbook, you must use which of the following under which conditions?

1) The data is in the same folder as the current workbook

2) The data is in a different folder than the current workbook

3) The data is in a different workbook

4) The data is in a different worksheet within the same workbook

Final answer:

When referencing data in another workbook, you must use relative references, including the folder path and file name if necessary.

Explanation:

When referencing data in another workbook, you must use relative references. Relative references specify the location of the data in relation to the current workbook. The conditions vary depending on the location of the data:

• The data is in the same folder as the current workbook: In this case, you can simply reference the file name without a folder path.
• The data is in a different folder than the current workbook: You need to include the folder path along with the file name when referencing the data.
• The data is in a different workbook: You need to include the file path and the file name when referencing the data.

Therefore, the correct options for referencing data in another workbook are 2) The data is in a different folder than the current workbook and 3) The data is in a different workbook.