Which statement is false with regards to using Calculated Items?

Answer 1

Calculated fields do not automatically update when new data is added to the PivotTable

Answer 2

Calculated fields allows expansion/collapsing like regular grouping levels

Answer 3

To avoid double-counting in your PivotTable you must filter out the items that contribute to a Calculated Item, as the original items are included in totals and subtotals along with the original items

Answer 4

Don’t know

Answer 5

… but when you get there you find the option is unavailable because you need to select a row item first

Answer 6

… but when you get there you find the option is unavailable. Instead you select the names Burgers and Sandwiches on the left side of the PivotTable, right-click them and choose Group

Answer 7

… you click Calculated Item, provide a name for the new item, click in the formulas area, select the Category on the left and then choose all the sales items you’d like to include

Answer 8

Don’t know

Answer 9

You need to refresh the PivotTable first, then drag it on to the PivotTable from the Item list

Answer 10

You need to drag it on to the PivotTable from the field list

Answer 11

None, it is added automatically

Answer 12

Don’t know

Which statement is false with regards to using Calculated Items?

You have the PivotTable shown below and decide to set up a Calculated Item to group the Burger and Sandwiches items from the Categories field. You select a cell in the values area, go to the PivotTable Tools > Analyze (Options tab in 2010) > Fields, Items and Sets …

Assume that you have just created a new Calculated Item for your PivotTable. What steps need to be taken to actually add it to the PivotTable?