87. To create a PivotTable, click the Recommended PivotTables button in the A. H

Question

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

Explanation / Answer

87. Ans -B- insert , pivot table otion is present in insert ribbon

88. Ans- C -Home , sort and filter option is in home tab

89. Ans- C - insert tab charts are present on Insert tab

90. Ans-A -column as moving right columns are included

91. Ans-B-worksheets we can sort worksheet data

92.Ans -C- Charts one cannot create charts on shared workbook

93.Ans D : bar charts are like colums

94. Ans : A : Sorting is rearranging data

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.