1.                  Outlining and Grouping your Data helps you to

A.                  Hide levels of detail in a workbook

B.                 Arrange the data you can print only summary information

C.                 A only

D.                 A and B

 

 

2.                  A PivotTable is used to

A.                  Protect a worksheet

B.                 Share a workbook

C.                 Perform linear programming

D.                 Explore relationships in your data

 

 

3.                  A Scenario is

A.                  An Excel 2003 add in

B.                 A version of a worksheet based on a particular set of data that can be saved for later viewing

C.                 A description of how to use an Excel feature

D.                 A and C

 

 

4.                  Goal Seek can be used to

A.                  Find and replace incorrect text

B.                 Find an appropriate help topic for a given situation

C.                 Find a number that satisfies a specific target value for a formula

D.                 None of the above

 

 

5.                  The solver is used for

A.                  Finding the right function for a given task

B.                 Merging formulas in workbooks

C.                 Finding solutions to a complex system of equations involving multiple variables and constraints

D.                 A and B

 

 

6.                  Which of the following is true

A.                  You can only save two scenarios

B.                 You cannot chart a PivotTable

C.                 Solver can be used as an advanced goal seek tool

D.                 You must use automatic outlining to group data

 

 

7.                  To refresh a PivotTable

A.                  Click the (!) red exclamation mark

B.                 Click the Update button on the refresh toolbar

C.                 Choose File->Update from the file menu

D.                 A or C

 

 

8.                  To use Goal Seek

A.                  Click the goal seek button on the standard toolbar

B.                 Right click on any cell and select goal seek from the menu

C.                 Choose Tools->Options->Goal Seek from the menu bar

D.                 Choose Tools->Goal Seek from the menu bar

 

 

9.                  To create a PivotTable report

A.                  Choose File->PivotTable from the menu bar

B.                 Choose Data->PivotTable and PivotChart report

C.                 Choose Tools->Options->PivotTable

D.                 Choose View->toolbars->PivotTable toolbar

 

 

10.             You can add or remove data to and from a pivot table by

A.                  Dropping and dragging PivotTable fields

B.                 Clicking the add data button on the standard toolbar

C.                 You cannot add or remove data to or from a pivot table

D.                 You can add data, but you cannot remove it