Deck 99: Advanced Spreadsheet Tools

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

A) creating tables
B) entering formulas
C) dragging fields
D) copying

Answer 3

C

Question 4

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

Question 5

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

A) Pivot
B) Options
C) Name
D) TableName

Question 6

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

Question 7

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

A) font
B) theme
C) animation
D) style

Question 8

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

Question 9

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

A) to the left of the sheet containing the PivotTable data
B) to the right of the sheet containing the PivotTable data
C) at the front of the list of worksheets
D) at the end of the list of worksheets

Question 10

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

Question 11

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

A) PowerPivot Tools
B) PivotTable
C) PivotTable
D) PowerPivot

Question 12

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

A) formats
B) data
C) formulas
D) constraints

Question 13

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

A) Number
B) Settings
C) Select
D) Field List

Question 14

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

Question 15

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

Question 16

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

Question 17

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

A) interactive
B) static
C) conditional
D) independent

Question 18

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.

Question 19

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

A) Linear programming options were enabled in Excel Options.
B) All Add-ins were enabled on the Tool menu.
C) The Solver Add-in was enabled from Add-ins on the Tools menu.
D) A what-if analysis was created,which enabled the Solver Add-in.