Question 1

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

Accepted Answer

A)   Number
B)   Settings
C)   Select
D)   Field ListE) C) and D)
F) A) and B)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of Use ____________________ Seek to determine a value...

Question 6

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

Accepted Answer

A)   Pivot
B)   Options
C)   Name
D)   TableNameE) None of the above
F) B) and C)

Question 7

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

Accepted Answer

A)   formats
B)   data
C)   formulas
D)   constraintsE) B) and D)
F) All of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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.

Accepted Answer

A) True 
 B)False  True

Question 10

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

Accepted Answer

A)   font
B)   theme
C)   animation
D)   styleE) B) and C)
F) None of the above

Question 11

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

Accepted Answer

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 worksheetsE) None of the above
F) A) and D)

Question 12

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

Accepted Answer

A) True 
 B)False  True

Question 13

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

Accepted Answer

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.E) B) and D)
F) A) and B) C

Question 14

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

Accepted Answer

A)   interactive
B)   static
C)   conditional
D)   independentE) A) and D)
F) B) and C)

Question 15

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

Accepted Answer

A)   PowerPivot Tools
B)   PivotTable
C)   PowerPivotD) B) and C)
E) A) and C)

Question 16

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

Accepted Answer

The answer of To create a PivotTable,click the ____________________ tab,and...

Question 17

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

Accepted Answer

The answer of In Excel,the ____________________ is used for solving...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   creating tables
B)   entering formulas
C)   dragging fields
D)   copyingE) A) and B)
F) A) and C)

Exam 99: Advanced Spreadsheet Tools

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified
True

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
True

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

Correct Answer
verified
C

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 99: Advanced Spreadsheet Tools

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified