> > >

Excel MCQs

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

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

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

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

d. All of the above

Answer

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

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