Answered

Which of the following is true about inserting cells in a worksheet?
Select one:
O a. Cells below the inserted cells are always moved downward.
O b. Excel automatically adjusts cell references to reflect new formula locations.
Oc. You cannot insert cells in a worksheet.
Od. You need to adjust cell references in all formulas that have moved.



Answer :

GinnyAnswer

Final answer:

Excel automatically adjusts cell references when inserting cells, ensuring formula accuracy.


Explanation:

Cell referencing in Excel is crucial for maintaining accurate formulas. When inserting cells in a worksheet, Excel automatically adjusts cell references to reflect new formula locations, ensuring formula accuracy. This feature helps users save time and prevent manual errors.


Learn more about Excel cell referencing here:

https://brainly.com/question/45362084