Question

How to create a Pivot Table?

• A. Insert -----> Pivot Table
• B. Data -----> Pivot Table
• C. Format -----> Pivot Table
• D. Insert -----> Data -----> Pivot Table

Answer 1

Answer:

B. Data -----> Pivot Table

To Find a Subtotal

       Data ----> Subtotal

To create a Scenarios

       Tools ------> Scenarios

To create Pivot Table

       Data ------> Pivot Table

Automatic repetitive task with macros

       Tools -------> Macro

•  Click 'Record New Macro'.
• Type a name for the new macro in 'Macro Name box'. Click OK
• Execute the steps that make up the macro
• Click 'Stop Recording' Button on the stop Recording toolbar.

Protecting Work books

• Protecting a workbook prevents changes to the worksheets
• To protect a workbook choose

             Tools ----> Protection -----> Protect workbook  dialogbox appears.