Excel - Intermediate 4 - UNITED COMPUTER CONSULTANTS

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

* 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. *

submit

Use the audio player above to hear answers and helpful hints

Go to top

Excel Knowledge TestIntermediate Level 4

Excel Knowledge Test
Intermediate Level 4