Matching
Match each of the following references to its best description:
Premises:
B3
'[International Falls.xlsx]Qtr 3 Sales'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'C:\Data[Minneapolis.xlsx]Sheet1'!A1
Responses:
Cell reference in the same worksheet.
External reference in which source workbook is in a different folder than the destination workbook.
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.
External reference in which Workbook or worksheet name contains spaces;source and destination files are in the same folder.
Correct Answer:
Premises:
Responses:
B3
'[International Falls.xlsx]Qtr 3 Sales'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'C:\Data[Minneapolis.xlsx]Sheet1'!A1
Premises:
B3
'[International Falls.xlsx]Qtr 3 Sales'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'C:\Data[Minneapolis.xlsx]Sheet1'!A1
Responses:
Related Questions
Q4: Match each of the following terms to
Q5: Hyperlinks can be used to build a
Q7: Match each of the following concepts to
Q11: To edit or remove a hyperlink _.<br>A)left-click
Q31: _ locks 2 windows together and enables
Q38: You can apply uniform page layouts to
Q45: What is the feature that warns users
Q50: Objects such as charts cannot contain hyperlinks.
Q73: Hyperlinks must link to websites.
Q82: The worksheet name in a 3-D reference