Exam 99: Advanced Spreadsheet Tools

A PivotTable is an Excel table that is used to provide different views of a range of data to assist in the analysis of the data.

Solver is now present in the Analysis group on the Data tab.What was done to add Solver to the Ribbon?

In the Goal Seek dialog box,Excel asks for three pieces of data.

Excel data analysis tools are located in the Analysis group on the Data tab.

A PivotTable is a(n)____ Excel table that's used to summarize a range of data for easy reporting and analysis.

In Excel,the ____________________ is used for solving linear programming types of problems.

The purpose of Solver is to find the optimal solution to a problem,given certain ____.

In Excel,the term "what-if analysis" means trying out different values in a worksheet to see how the formula results change.

An Excel PivotTable can have a(n)____ applied,so that its rows and columns appear in color.

A PivotTable is set up by ____ from the PivotTable Field List to label and filter areas.

To create a PivotTable,click the ____________________ tab,and then click the Summarize with PivotTable button in the Tools group.

In Excel,to use the Solver,you must first purchase it.

Use ____________________ Seek to determine a value that will produce a goal such as a specific monthly payment.

A PivotTable's name is changed by clicking the ____ button on the PivotTable tab to open the PivotTable Options dialog box.

When creating a new PivotTable to be placed on a new worksheet,the new worksheet is placed ____.

On the PivotTable tab,which button should you click to format a number displayed in the PivotTable?

When creating a PivotTable,the usual first step in the process is to convert the data in the worksheet to a table.

A PivotTable can be formatted so that its output looks similar to a row.

Working in a PivotTable causes the ____ tab to appear on the Ribbon.