Excel Formula References: Why Copying Formulas Sometimes Goes Wrong

Have you ever copied a formula to another tab in your workbook, and the result was not at all what you expected? Moved a formula to a new location and were surprised that it didn’t change?