What is the result when a user edits an average value in a crosstab worksheet?

• A. The average value remains unchanged
• B. The average value is applied to all detailed records
• C. The average value is eliminated
• D. The average value is saved as is without changes

Answer: (B)

When a user edits an average value in a crosstab worksheet, the average value is applied to all detailed records associated with that calculated average. This is because averages in crosstab reports represent a summary calculation of the underlying data points. When a user alters the average, it effectively adjusts the contributions of the underlying records to align with the new average.

Thus, each detailed record that contributes to the computed average will reflect this change, ensuring consistent representation across the summarized data. This function is particularly useful for maintaining the integrity of data analysis within the crosstab as it ensures that user-edit actions are holistic and consider all contributing elements.