1-How would you prevent Excel from applying more than one conditional format to a PivotTable cell?

1. In the Conditional Formatting Rules Manager, right-click the rule and then click Apply This Rule Only.
2. Go to the Excel Options dialog box, display the Formatting page, and check the Apply single conditional format only box.
3. No action is needed -- this is the default behavior.
4. Check the Stop If True box next to the rule in the Conditional Formatting Rules Manager.

2-Once you create a macro for your Purchase Order Pivot Table, how do you save the macro?

1. Ensure the file name has a .xlsx extension, then click Save.
2. Use Save As, then in Save as Type select Excel Macro-Enabled Workbook.
3. Use Save As, then in Save as Type select Visual Basic Editor.
4. Ensure the file name includes Macro in the name, then click Save.

3-How would you arrange your PivotTable to show the quantity sold for each product and each products contribution to total quantity sold?

1. Use two copies of the same field and dragging Quantity to Values in the Field List area.
2. Drag the Unit Price field to Values in the Field List area.
3. Use two copies of the same field and changing Show Values as to % of Column Total.
4. Drag the Quantity field to Values in the Field List area

4-To avoid errors, what is the first step you should take after you start recording a PivotTable macro?

1. Remove all formatting from the PivotTable.
2. Create a new PivotTable on a new worksheet.
3. Clear the PivotTable.
4. Remove all fields from the data area.