Back to lesson
1. When linking between workbooks, what sheets should specifically be included for the task?
A Model Import Sheet in the destination workbook only.
A Model Export Sheet in the source workbook and a corresponding Model Import Sheet in the destination workbook.
A Model Export Sheet in the source 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 Special as Values
Copy, then Paste
Copy, then Paste Special as Formulas
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 + V
ALT + E + S + F
ALT + E+ S + T
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement