Solved

Match Each of the Following References to Its Best Description

Question 93

Matching

Match each of the following references to its best description:

Premises:

Responses:

'C:\Data[Minneapolis.xlsx]Sheet1'!A1

External reference in which source workbook is in a different folder than the destination workbook.

[mineapolis.xlsx]Qtr3!A1

External reference in which Workbook or worksheet name contains spaces; source and destination files are in the same folder.

'[St Paul.xlsx]Qtr3'!A1

Cell reference in the same worksheet.

'[International Falls.xlsx]Qtr 3 Sales'!A1

External reference in which Workbook and worksheet names do not contain spaces; source and destination files are in the same folder returning the same value for ties.

External reference in which Worksheet name contains spaces; source and destination files are in the same folder.

Premises:

'C:\Data[Minneapolis.xlsx]Sheet1'!A1

[mineapolis.xlsx]Qtr3!A1

'[St Paul.xlsx]Qtr3'!A1

'[International Falls.xlsx]Qtr 3 Sales'!A1

Responses:

External reference in which source workbook is in a different folder than the destination workbook.

External reference in which Workbook or worksheet name contains spaces; source and destination files are in the same folder.

Cell reference in the same worksheet.

External reference in which Workbook and worksheet names do not contain spaces; source and destination files are in the same folder returning the same value for ties.

External reference in which Worksheet name contains spaces; source and destination files are in the same folder.

Correct Answer:

Premises:

Responses:

'C:\Data[Minneapolis.xlsx]Sheet1'!A1

[mineapolis.xlsx]Qtr3!A1

'[St Paul.xlsx]Qtr3'!A1

'[International Falls.xlsx]Qtr 3 Sales'!A1