138k views
1 vote
When you use the fill handle to copy a formula to adjacent cells, this creates what kind of cell reference?

A. Relative
  B. Active
  C. Absolute
  D. Mixed

2 Answers

3 votes

yeah its a because it is relative

User Tom Tregenna
by
8.9k points
5 votes
The correct option is A.
One can quickly copy a formula into adjacent cells by using fill handle option. When one fills the formula down, relative reference are used to ensure that the formula adjust for each row, unless one include the the absolute or mixed reference before one fills down the formula.
User Liubov
by
9.3k points