In my experience working with Excel, one of the most common mistakes using formulas are related to the misuse of relative and absolute cell references,
but not necessarily because not knowing the terms, but mostly because it is easy to forget the right structure when creating a formula.
In this video I will show you the difference between a relative and an absolute Cell reference and how to use them