These questions are for excel formats:

1. If changes are made in the worksheet that contained the original data used to generate a pivot table, the table is automatically updated. T or F _____________

2. Which method is better. Formatting numbers by clicking on the cells inside the pivot table or by going through the Pivot Table Fields dialog box? __________

3. You cant change the type of arithmetic to perform in a pivot table field. It must always be a Sum function. T or F? _____________

4. Can you apply filters to the data after you have created the pivot table? Y or N __________________