Ask Question
28 December, 14:08

The formula in cell B1 is = A$2. Autofill is used by dragging B1's autofill box across to C1, D1, and E1. What formulas will appear in C1, D1, and E1, respectively?

+2
Answers (1)
  1. 28 December, 14:43
    0
    The formulas that will appear in

    C1 is = B$2

    D1 is = C$2

    E1 is = D$2

    Step-by-step explanation:

    Given

    Formula in B1 is = A$2

    Required

    Formulas in C1, D1 and E1 when dragged from B1.

    In Microsoft Office Excel, this is called absolute reference.

    But this type of absolute reference requires that only the cell name will be changed or altered, the row number will always remain the same no matter where it's been dragged to.

    Since the initial column name is A and the Initial row number is 2 (from A$2),

    Cell C1 will take the formula = B$2

    Cell D1 will take = C$2

    Cell E1 will take = D$2

    Notice that only the column name changed for each formula; the row number remain unchanged.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “The formula in cell B1 is = A$2. Autofill is used by dragging B1's autofill box across to C1, D1, and E1. What formulas will appear in C1, ...” in 📘 Mathematics 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