Quiz & Worksheet - Appending Multiple Excel Worksheets

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Which statement is true about the Consolidate tool?

If your workbook has 4 worksheets, you can consolidate just two of them. If you workbook has 4 worksheets, you can consolidate all of them into one new one. The Consolidate command let's you merge multiple Excel files together.

The Consolidate command also creates an outline on the master worksheet. All of these statements are true.

Worksheet

Print How to Append Multiple Worksheets Worksheet

1. Where in the ribbon will you find the Consolidate command?

Insert>Append
Home>Data
Data>Data Tools
Data>Append
Formulas>Data Tools

2. If you want to make sure that the master updates automatically if you change data to other referenced worksheets, what should you do?

Make sure that the Top Row box is checked.
Make sure that Link all worksheets together is checked.
Make sure that the Left Column box is checked.
Nothing. Excel does this by default.
None of these answers are correct.

Create your account to access this entire worksheet

A Premium account gives you access to all lesson, practice exams, quizzes & worksheets

Access to all video lessons

Quizzes, practice exams & worksheets

Certificate of Completion

Access to instructors

Create an account to get started Create Account

About This Quiz & Worksheet

This quiz and worksheet will increase your comprehension of the Consolidate command. The quiz will also assess your understanding of concepts like automatic updates and the Function command.

Quiz & Worksheet Goals

Use these assessment tools to:

Identify characteristics of the Consolidate tool
Determine the location of the Consolidate command
Understand how to update the master copy
Recognize how to show and hide detail information
Learn how to total everything up in the master worksheet

Skills Practiced

This worksheet and quiz let you practice the following skills:

Critical thinking - apply relevant concepts to examine information about adding a worksheet or multiple worksheets to an existing one
Interpreting information - verify that you can read information regarding the steps to merging worksheets and interpret it correctly
Information recall - access the knowledge you've gained regarding updating master sheets