5.) You have several pivot tables and you have formatted the color and fonts. But whenever you change the fifter or add any data, they lose the formatting. In which of the following ways, can this be prevented? (Assuming your columns are fairly consistent) 1. Go to Pivot options and select Preserve Formatting 2. Go to Conditional Formatting and set a Rule Choose the correct answer from the options given below. Neither 1 no 2 Only 1 Both 1 and 2 Only 2