Copyright

Copying Formulas with the Excel Fill Handle

Instructions:

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

question 1 of 3

Where is the fill handle on a cell?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,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. Which of these does NOT happen with the fill handle?

2. If you were to use the fill handle to copy a formula in cell C4 that was A4-B4, where would you expect to find the difference of A54-B54?

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

We put together this helpful quiz/worksheet combo to give you a resource you can use at your leisure to check your comprehension of using copying formulas with the Excel fill handle. Just a few of the topics covered here include the functions related to the fill handle and the directions that the fill handle can be dragged.

Quiz & Worksheet Goals

This quiz is a helpful way to see if you know:

  • Where the fill handle is located on a cell
  • The functions related to the fill handle
  • How the fill handle copies a formula from different cells and its result
  • What comes next in a set of data when you use the fill handle
  • The directions the fill handle can be dragged

Skills Practiced

  • Knowledge application - use your knowledge to answer questions about where the fill handle is located on a cell
  • Information recall - access the knowledge you've gained regarding what would come next in a data set when you've used the fill handle
  • Reading comprehension - ensure that you draw the most important information from the related lesson about copying formulas using the fill handle in Excel

Additional Learning

Our lesson called Copying Formulas with the Excel Fill Handle is a handy way to learn more about this subject. After you complete this lesson, you should be able to:

  • Identify the item that is required for the fill handle to work properly
  • Explain the other uses for the fill handle beyond formulas
  • Discuss what is meant by relative direction when using the fill handle
Support