Using the Data on the "Data" tab. Answer the following questions. You should make at least one copy of the data sheet called format.

Create a Regular Table

Any product type of watches, knives and binoculars except where the product name contains the word edge and only if the quanity was greater than $100$

Create a pivot table:

For the store type Outdoor, and the category camping equipment, find the top three selling products by sum of revenue

For the category golf equipment, in the product type woods, find the top three products by count

Conditional format $($on format sheet$)$:

Use conditional formatting to highlight all rows that are golf equipment over $$10,000$ that are from Q$22014$

Use conditional formatting to highlight the quantity column with color scales.Using the Data on the "Data" tab. Answer the following questions. You should make at least one copy of the data sheet called format.

Create a Regular Table

Any product type of watches, knives and binoculars except where the product name contains the word edge and only if the quanity was greater than $100$

Create a pivot table:

For the store type Outdoor, and the category camping equipment, find the top three selling products by sum of revenue

For the category golf equipment, in the product type woods, find the top three products by count.

Conditional format $($on format sheet$)$:

Use conditional formatting to highlight all rows that are golf equipment over $$10,000$ that are from Q$22014$

Use conditional formatting to highlight the quantity column with color scales.

how would i only do the pivot tables?