Which of These Steps Will You Choose to Refresh Data

question 18

Multiple Choice

Which of these steps will you choose to refresh data in a Pivot Chart?

• A) Right-click on the Pivot Chart and select Refresh
• B) Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Refresh Status
• C) Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Cancel Refresh
• D) Click Analyze > Options > Layout & Format tab > Check Autofit column widths on update and Preserve cell formatting on update boxes

---

Definitions:

Normally Distributed

Describes a data set where most values cluster around a central mean value, forming a symmetric, bell-shaped distribution curve.

Standard Deviation

A statistical measurement of variability or dispersion within a set of data, indicating how spread out the numbers are from the average.

Mean

A statistical measure representing the average or central value of a set of numbers, calculated by adding all the values and dividing by the count of the values.

Z-score

A statistical measure representing the number of standard deviations a data point is from the mean of its distribution.