Excel - Intermediate 4

Use the link below to see a training video to assist with answering this questionnaire

Consolidate worksheets and linking: - https://youtu.be/INlGYSeUrdo

Excel Knowledge Test
Intermediate Level 4
Linking and Consolidation

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.

* Indicates required field

Name *

First

Last

Email *

What is "consolidation" and "linking"? *

Name an advantage of using linking formulas. *

What does an exclamation mark (!) mean in a linking formula? *

You have created a "Summary" file which draws (links) data from three source files. Which file needs to be active to be able to see the Edit Links dialogue box? *

A blank file Any of the source files The summary file

....and which tab contains the Edit Links command? *

Home Data Formula

Outline the steps to break a link between the source workbook and the destination workbook. *

Click here to join the mailing list to receive software tips and tricks

Use the audio player above to hear answers and helpful hints

Go to top

Excel Knowledge TestIntermediate Level 4Linking and ConsolidationComplete the test first, then listen to the answers by clickingon the audio player at the bottom of the page.

Excel Knowledge Test
Intermediate Level 4
Linking and Consolidation

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.