Ask Question
8 July, 17:19

2. When you use the fill handle to copy a formula to adjacent cells, this creates what kind of cell reference?

+3
Answers (2)
  1. 8 July, 20:08
    0
    Relative Reference

    Explanation:

    Cell references are considered to be relative references when cells is copied across multiple cells, causing them to change based on the relative position of rows and columns.

    For example, if you copy the formula = F1+G1 from row 1 to row 2, the formula will become = F2+G2.

    Another example, if you copy the formula = F4*G4 from cell H4 to H5, the formula in H5 adjusts to the right by one column and becomes = F5*G5.

    Relative references are often easier to adopt or use whenever you need to repeat the same calculation across multiple rows or columns.
  2. 8 July, 20:33
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “2. When you use the fill handle to copy a formula to adjacent cells, this creates what kind of cell reference? ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers