Matching
Match the following terms with the corresponding description:
Premises:
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c : \Data[Indianapolis.xlsx]Sheet1'!A1
B3
Responses:
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.
Cell reference
External reference in which Workbook or worksheet name contains spaces;source and destination files are in the same folder.
External reference in which Workbook and worksheet names do not contain spaces;source and destination files are in the same folder.
Correct Answer:
Premises:
Responses:
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c : \Data[Indianapolis.xlsx]Sheet1'!A1
B3
Premises:
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c : \Data[Indianapolis.xlsx]Sheet1'!A1
B3
Responses:
Related Questions
Q1: Match the following terms with the corresponding
Q33: When a stop is chosen as the
Q37: Conditional formatting can be applied to a
Q63: In Excel,hyperlinks appear as:<br>A)blue text with a
Q71: When worksheets are grouped _ appears in
Q75: OctoberSales.xlsx is an example of CamelCase notation.
Q77: _ is/are a set of tools that
Q80: The IFERROR function will perform an action
Q86: A_ is a pointer to a cell
Q91: Which of the following would cause the