Exam 52: Advanced Spreadsheet Tools

Use the ____ option to help resolve a problem when you know your target value but two or more variables remain unknown.

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

To focus on a smaller portion of your spreadsheet's PivotTable data for analysis,use the ____ tool.

PivotTables,PivotCharts,and Slicers are all examples of Excel functions.

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

With the ____ option,you can plug values into an existing formula within a spreadsheet until you achieve the set of result assigned.

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

A PivotTable's name is changed by clicking in the ____ Name box in the PivotTable group on the PIVOTTABLE TOOLS Options tab.

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

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

Which add-in should be enabled so that you can predict future auto sales based on past years' performance?

A graphical representation of data in a spreadsheet's PivotTable is referred to as a ____.

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

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.

Data is added to an existing PivotTable by ____ from the PivotTable Field List to its label and filter areas.

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