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
Cell reference
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.
External reference in which source workbook is in a different folder than the destination workbook.
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
Q13: To compare monthly mortgage payments,total amounts to
Q14: Match the following terms with the corresponding
Q15: Match the following terms with their meanings:
Q16: Data tables can be constructed using one,two,or
Q17: To optimize the monthly payments,you would designate
Q19: The _ value replaces the original input
Q20: Best-Case,Worst-Case,and Mostly Likely are descriptive names used
Q21: When entering text to be displayed in
Q22: Match the following terms with the corresponding
Q23: To compare monthly mortgage payments based on