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, I10, H11, I11, I12 and I16 would all show as blanks.

Answer 10

Cells H10, H11 and I12 would show as zero. Cells I10, I11 and I16 would 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?