Using the AutoFill Tool in Excel

Instructions:

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

question 1 of 3

The small square in the bottom, right-hand corner of a selected cell or range is referred to as what?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 75,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. When starting a number fill that will follow a numeric sequence, Excel needs to see a pattern to get started. How many numbers in the list do you need to enter?

2. If you wanted to copy data in the first cell down an entire column, stopping at the last row of data in the spreadsheet, what steps would you use?

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

If used properly, the AutoFill tool in Excel can save a lot of time.When you take the quiz on this subject, you'll need to know specifically what the small square in the bottom, right-hand corner of a selected cell is called and how many numbers need to be entered when starting a number fill to permit a numeric sequence.

Quiz & Worksheet Goals

Find out your ability to:

  • Recognize the steps to use when copying data in the first cell down a whole column
  • Name the type of data which works with the AutoFill feature
  • Give another word for clicking and holding with the mouse

Skills Practiced

Use the quiz and worksheet to practice the following skills when you study:

  • Reading comprehension - ensure that you draw the most important information from the related lesson on the AutoFill tool in Excel
  • Critical thinking - apply relevant concepts to examine information about numbers in a spreadsheet in a different light
  • Knowledge application - use your knowledge to answer questions about Excel

Additional Learning

Review this lesson on the AutoFill feature in Excel. The lesson is named Using the AutoFill Tool in Excel and it will cover the following objectives:

  • Analyze filling data in a column
  • Explain using the AutoFill to copy data
  • Understand how to fill data across a row
Support