What right-click option gives you the ability to flag specific cells to ensure the data is not overwritten?

What right-click option gives you the ability to flag specific cells to ensure the data is not overwritten?

• A. Data Attachment
• B. Allocation
• C. Cell Detail
• D. Spreading

Answer: (D)

Flagging cells to prevent overwriting happens during the data-entry flow when you use the spreading feature. Right-clicking and choosing spreading lets you enter or propagate values across a range while marking specific cells as protected, so those cells won’t be overwritten by subsequent spread operations. This protects important data as you distribute values. The other options serve different purposes: attaching data to a cell, distributing a value across dimensions, or viewing cell details, none of which provide a mechanism to lock or flag a cell to guard against overwriting.

Flagging cells to prevent overwriting happens during the data-entry flow when you use the spreading feature. Right-clicking and choosing spreading lets you enter or propagate values across a range while marking specific cells as protected, so those cells won’t be overwritten by subsequent spread operations. This protects important data as you distribute values. The other options serve different purposes: attaching data to a cell, distributing a value across dimensions, or viewing cell details, none of which provide a mechanism to lock or flag a cell to guard against overwriting.