Question
Layne wants to set up her PivotTable to show which month had the highest percentage of her total sales. After right-clicking on one of the values, which options should she choose to convert the values to a percent?
(1 point)
Responses
Show Field List
Show Field List
Remove Values
Remove Values
Show Values As…
Show Values As…
Value Field Settings
Value Field Settings
(1 point)
Responses
Show Field List
Show Field List
Remove Values
Remove Values
Show Values As…
Show Values As…
Value Field Settings
Value Field Settings
Answers
GPT-4o mini
To convert the values to a percentage in her PivotTable, Layne should choose the option **"Show Values As…"**. This will allow her to set the values to display as a percentage of the total sales.