Conditional formatting Sorting Remove duplicates Which option best describes how a pivot table works? $(1$ Point$)*$ A pivot table is a formula$-$driven tool used to calculate complex mathematical equations A pivot table is a function that sorts data in alphabetical or numerical order A pivot table is a feature that automatically creates charts and graphs based on the data selected A pivot table is a dynamic summary tool that allows users to reorganize and summarize large amounts of data How do you move a pivot table to an existing worksheet? $(1$ Point$)*$ Use the "Format" tab and select "Move Pivot Table" Use the "Data" tab and select "Move Pivot Table" from the "Manage Data Model" group Use the "Pivot Table Analyze" tab and select Existing Location within the Move Pivot Table function