ECDL Exam ECDL-ADVANCED Topic 5 Question 63 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 63
Topic #: 5

Which option of Paste Special is used to link cells in different worksheets?

AFormat Link

BPaste Link

CPaste Format

DLink Cell
Explanation:
The Paste Link button is used to link cells in different worksheets.
Take the following steps to link cells in different worksheets:
Select and copy the cells that you want to link to the other worksheet.

Select the desired destination in another worksheet.

Click the Paste drop down icon, select the Paste Special option, and click the Paste Link button.

If you take a look at the resulting formula, it will include the filename, sheet name, and cell reference to the original data.

Answer options A, D, and C are incorrect. These are not valid options of Paste Special.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Paste Link'
Chapter: ADVANCED SPREADSHEETS
Objective: Data Handling

Show Suggested Answer

Suggested Answer: B

by Sylvia at Dec 25, 2022, 07:51 PM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!