Back to lesson
1. When linking between workbooks, what sheets should specifically be included for the task?
A Model Export Sheet in the source workbook only.
A Model Export Sheet in the source workbook and a corresponding Model Import Sheet in the destination workbook.
A Model Import Sheet in the destination workbook only.
2. When creating an Import Sheet based upon an already established Export Sheet, how should the layout and data be copied?
Copy, then Paste
Copy, then Paste Special as Formulas
Copy, then Paste Special as Values
3. When linking, one of the first things you should do is copy the export sheet and paste it onto an import sheet as values. Which of the following is a keyboard shortcut for pasting copied cells as values?
ALT + E + S + F
ALT + E + S + V
ALT + E+ S + T
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement