MICROSOFT EXCEL NOTE AND WORKBOOK 3. The PivotTable will adjust—or pivot—to show the new data. In our example, it now shows the amount sold by each region. 205 | P a g e