The following PivotTable is configured with Category on rows, Week on columns and Units on Values. You’d like to change the PivotTable so that it displays with no decimal places. How should you modify it to make that happen?

Answer 1

Right-click one of the values > Value Field Settings > Number Format > Select the number format you’d like to use

Answer 2

Select all values in the body of the PivotTable > go to the Home tab > click the “Decrease Decimal” button

Answer 3

Right-click one of the values > Format Cells > Number > Select the number format you’d like to use

Answer 4

Don’t know

Answer 5

Right-click one of the values > Value Field Settings > Number Format > Select a number format that displays zeros properly

Answer 6

Type a 0 in all the empty cells

Answer 7

Right-click the PivotTable > PivotTable Options > check the box next to “For empty cells show” and enter a 0

Answer 8

Don’t know

Answer 9

Cells H10, H11 and I12 would show as zero. Cells I10, I11 and I16 would show as blanks

Answer 10

Cells H10, I10, H11, I11, I12 and I16 would all show as blanks

Answer 11

Cells H10, I10, H11, I11, I12 and I16 would all show as zero

Answer 12

Don’t know

This PivotTable looks like it has holes in it. How would we fix that and plug the empty cells with 0?