Matching
Match the following terms with the corresponding description:
Premises:
B3
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c :\Data[Indianapolis.xlsx]Sheet1'!A1
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
Responses:
External reference in which Workbook and worksheet names do not contain 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.
Cell reference
External reference in which Worksheet name contains spaces;source and destination files are in the same folder
External reference in which source workbook is in a different folder than the destination workbook.
Correct Answer:
Premises:
Responses:
B3
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c :\Data[Indianapolis.xlsx]Sheet1'!A1
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
Premises:
B3
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c :\Data[Indianapolis.xlsx]Sheet1'!A1
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
Responses:
Related Questions
Q18: What auditing tool is best used to
Q19: What is the proper format of an
Q20: What formula auditing tool can be used
Q21: When arranging windows,tiled is not an option.
Q22: _ is a file containing a pointer
Q24: A _ is an electronic marker that
Q25: _ is/are not supported when worksheets are
Q26: What are the benefits of using 3-D
Q27: What is the proper format for creating
Q28: When a worksheet is split,any changes made