Copyright

How to Append Multiple Worksheets - Quiz & Worksheet

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?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 84,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

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

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

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

Additional Learning

To learn more about Excel, review the lesson, How to Append Multiple Worksheets, which covers the following objectives:

  • Define append
  • Determine the purpose of the Consolidate command
  • Understand how to create a link between spreadsheets in Excel
  • Learn how to format the master copy of consolidated spreadsheets
  • Identify how to consolidate multiple Excel files
Support