> > >

Excel MCQs

What could you do to stop the pivot table from losing the column width upon refreshing?

Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and disable the “Auto Format” options.

Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and enable the “Auto Format” options.

Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable the “Auto Format” options.

All of the above

Answer

Correct Answer: Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable the “Auto Format” options.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it