If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?
A)It becomes =$P$24
B)It remains =$N$21
C)It becomes =$L$18
D)It becomes =$Q$23

Question

Quizplus · Accepted Answer

When columns are inserted before column N, the column reference shifts to the right, changing N to P. When rows are inserted above row 21, the row reference shifts down, changing 21 to 24. Thus, =$N$21 becomes =$P$24.

If a Cell Contains =$N$21 and Two New Columns Are