87. To create a PivotTable, click the Recommended PivotTables button in the A. Home B. Insert C. Formulas D. Data tab of the Ribbon. ab, in the Editing group, click the 88. To filter data, on the_ Sort &Filter button. A. Insert B. Design C. Home D. File 89. To hide or show chart elements and control their appearance and position, use thet A. Chart Tools Design B. Chart Area C. Insert D. Formatting ab 90. When you add data to the right of the table, Excel includes the new in the table automatically. A. column B. row C. total D. Sparkline by text, by date, or by values. 91. You can sort A. alphabetically B. worksheets C. workbooks D. styles in a shared workbook. 92. You cannot create a A. worksheet B. chart C. table D. data range charts are like column charts turned on their side. 93 A. Line B. Pie c. Clustered column D. Bar 94 rearranges the rows in your worksheet by the data in a column A. Sorting B. Validating c. Consolidating D. Grouping