feature. Combining VLOOKUP with a Pivot Table Now that you have the data table in columns A through E, a Pivot Table can be used to summarize the data on a number of factors. To create the Pivot Table, select the data in columns A through E. Next, navigate to the Insert tab and click Pivot Table. Using the dialog box, place the Pivot Table in cell J10. Finally, using the Pivot Table Fields task pane on the right, create the Pivot Table below and fill in the values. NOTE: For the Sum of Gross Sales column, round answers to the nearest cent and do not enter a dollar sign ( $). Row Labels Sum of Order Quantity Sum of Gross Sales ($) Battery Pack Bluetooth Headphones $ Carry-on Suitcase LA Travel Pillow Travel Umbrella Grand Total