does the autofill feature create a new formula for every cell in the document?

Answer 1

No, the autofill feature does not create a new formula for every cell in the document. Instead, it copies the formula from the original cell and adjusts the cell references as needed when the formula is dragged or copied to adjacent cells. This allows users to quickly fill in a series of cells with similar formulas without having to manually type out the formula each time.