Why is it necessary to use care when inserting worksheet cells?
A) It might automatically change the functions you are using.
B) It can change relative references to absolute references in formulas.
C) You will have to manually correct cell references in formulas.
D) It may disturb row or column alignment,which can affect worksheet accuracy.

Question

Quizplus · Accepted Answer

When cells are inserted or deleted, it can affect the alignment of rows and columns. This can lead to inaccurate calculations and overall disrupt the worksheet layout. Therefore, it is necessary to use caution when manipulating cells in order to maintain accuracy and efficiency. The other options listed may occur as a result of cell manipulation, but they are not the primary concern when it comes to using care when inserting cells.

Why Is It Necessary to Use Care When Inserting Worksheet