Matching
Match each of the following references to its best description:
Premises:
'C:\Data[Minneapolis.xlsx]Sheet1'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'[International Falls.xlsx]Qtr 3 Sales'!A1
B3
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
B3
Premises:
'C:\Data[Minneapolis.xlsx]Sheet1'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'[International Falls.xlsx]Qtr 3 Sales'!A1
B3
Responses:
Related Questions
Q24: The _ is the file which holds
Q25: E:\Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a
Q26: Camel Case notation capitalizes the first letter
Q27: The Fill Across Worksheets command is _.<br>A)only
Q28: By default, a visited text hyperlink in
Q30: To setup Split Windows, Synchronous Scrolling or
Q31: _ locks 2 windows together and enables
Q32: _ is the dependent cell with this
Q33: Match each of the following concepts to
Q34: Which of the following formulas contains an