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 can't 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 __________________