In Excel, the dollar sign fixes a cell's column or row when you copy the formula—absolute ($A$1), relative (A1), or mixed ($A1 or A$1). For my cloth inventory in Ahmedabad, I use mixed reference like A$2 to lock the monthly rate row while moving across customer columns. Everyone says absolute is most important, but my life on the shopfloor says mixed is the real jugaad—it saved me when tracking GST for different product lines.
#exams#study
Jump in to reply — no account needed.