What feature distributes entered values to existing current cell values?

The Adjust Values feature is designed specifically to distribute entered values across existing current cell values effectively. When using this feature, users can enter a total value, and the system automatically allocates that total proportionally among the selected cells based on their existing values. This allows for a seamless update to the figures within the context of the existing data set, maintaining the relative proportions during the adjustment.

For example, if you have several line items each representing a portion of a budget, and you want to adjust this budget by a certain amount, the Adjust Values feature enables you to quickly scale those figures without manually recalculating each item.

In contrast, other options do not offer this specific functionality. The Increment adjustment is typically used for adding a fixed amount to each cell rather than redistributing an entered value. Even adjustment suggests distributing values evenly across selected cells without regard to their current values, which is not the same as adjusting based on existing data. Read-only cells, meanwhile, are not intended for any adjustments, as they cannot be modified directly. Thus, the unique capability of the Adjust Values feature makes it the ideal choice for distributing entered values in the context described.