ECDL Exam ECDL-ADVANCED Topic 5 Question 100 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam

Question #: 100
Topic #: 5

[All ECDL ADVANCED WORD PROCESSING Questions]

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 Mabelle at Sep 15, 2024, 11:54 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Roslyn

7 days ago

B, Paste Link. It's the clear winner here. I can already see the formulas stretching across multiple sheets, like a beautiful web of data. Spreadsheet sorcery at its finest!

upvoted 0 times

...

Bambi

8 days ago

I'm not sure, but I'll go with B) Paste Link too.

upvoted 0 times

...

Maurine

11 days ago

I love a good spreadsheet challenge! Paste Link, all the way. It's the only option that makes sense for linking cells. Now, if only I could get my computer to do my taxes for me...

upvoted 0 times

Laurel

4 hours ago

I agree, Paste Link is the way to go for linking cells in different worksheets.

upvoted 0 times

...

Hassie

19 days ago

I'm pretty sure it's Paste Link. Linking cells is the way to go when you need to reference data from another worksheet. Saves time and keeps everything organized.

upvoted 0 times

...

26 days ago

Ah, the age-old question of linking cells across worksheets. This is a trick question if I ever saw one!

upvoted 0 times

Genevieve

11 days ago

It's actually quite simple, just use the Paste Link option in Paste Special.

upvoted 0 times

...

Anna

19 days ago

Me too, but I remember Paste Link is the one to use for linking cells across worksheets.

upvoted 0 times

...

Javier

26 days ago

I think the answer is B) Paste Link.

upvoted 0 times

...