FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which ribbon is visible when a PivotTable is selected, and allows a userto apply various styles to the PivotTable?

A	Layout
B	Options
C	Design
D	Format

Explanation:

Detailed explanation-1: -To create a blank Pivot Table: On the Insert tab of the Excel Ribbon, click the PivotTables command. The Create PivotTable dialog box opens, with 3 sections to fill in–Choose the Data, Choose Where, Data Model.

Detailed explanation-2: -There are 2 new tabs added to the ribbon (2) – PivotTable Analyze and Design. On the right hand side of the screen, (3) a task pane will appear with the Pivot table fields available.

There is 1 question to complete.