Question 1

A(n)_____ is a spreadsheet function that summarizes information by category.

Accepted Answer

The answer of A(n)_____ is a spreadsheet function that summarizes...

Question 2

Dragging a label from the PivotTable Field List to the area in the lower-right portion of the screen marked "Values" makes it three dimensional.

Accepted Answer

Dragging a label from the PivotTable Field List to the area in the lower-right portion of the screen marked "Report Filter" makes it three dimensional.

Question 3

A list does not contain any _____ rows.

Accepted Answer

The answer of A list does not contain any _____...

Question 4

From a list of customers living in the North,the South,the East,and the West,in order to get specific information to create a list of all customers living in the North,the _____ function must be used.

Accepted Answer

The answer of From a list of customers living in...

Question 5

The _____ quickly creates smaller lists out of a much larger list.

Accepted Answer

The answer of The _____ quickly creates smaller lists out...

Question 6

By creating a two-dimensional pivot table in Excel,using rows and columns,you can build a data warehouse.

Accepted Answer

A data warehouse can be built with rows,columns,and layers by simply creating a three-dimensional pivot table in Excel.

Question 7

The purpose of the AutoFilter function is to help you quickly focus on only the information that is important by _____ the information that is not.

Accepted Answer

The answer of The purpose of the AutoFilter function is...

Question 8

In using Goal Seek to compute an unknown value,the first step is to click on the "Value Fields" setting,then click on "Summarize Values By",and then select "Goal Seek".

Accepted Answer

In using Goal Seek to compute an unknown value,one has to click on "Data" from the menu bar,and then click on "What-If Analysis" and select "Goal Seek".

Question 9

In a list,each column has only _____ type(s)of information.

Accepted Answer

The answer of In a list,each column has only _____...

Question 10

A(n)_____ is a collection of information arranged in columns and rows in which each column displays one particular type of information.

Accepted Answer

The answer of A(n)_____ is a collection of information arranged...

Question 11

A(n)_____ is a description of a list by column.

Accepted Answer

The answer of A(n)_____ is a description of a list...

Question 12

A list is a collection of information arranged in _____ and _____ in which each column displays one particular type of information.

Accepted Answer

The answer of A list is a collection of information...

Question 13

_____ is Microsoft's spreadsheet software that allows you to work with and analyze information.

Accepted Answer

The answer of _____ is Microsoft's spreadsheet software that allows...

Question 14

A pivot table can be created for information obtained from a Word or Access table.

Accepted Answer

You can choose to use an external data source,such as a Word or Access table,for the creation of a pivot table.

Question 15

The first _____ in a list contains column headings or labels.

Accepted Answer

The answer of The first _____ in a list contains...

Question 16

The default location of a pivot table is to place it in the same worksheet as that of the list.

Accepted Answer

The default location of a pivot table is to place it in a new worksheet as that of the list.

Question 17

A pivot table can be two-or three-dimensional.

Accepted Answer

A pivot table can be two-or three-dimensional,depending on whether or not data is dropped in the report.

Question 18

A(n)_____ is the intersection of a row and column.

Accepted Answer

The answer of A(n)_____ is the intersection of a row...

Question 19

Goal Seek works backward from an objective to compute an unknown value.

Accepted Answer

Goal Seek works backward from an objective to compute an unknown value.

Question 20

To use Goal Seek,one has to create a worksheet that includes an objective based on some unknown value in a cell.

Accepted Answer

To use Goal Seek,one has to create a worksheet that includes an objective based on some unknown value in a cell.

Quiz 13: Decision Analysis With Spreadsheet Software

A(n)_____ is a spreadsheet function that summarizes information by category.

Dragging a label from the PivotTable Field List to the area in the lower-right portion of the screen marked "Values" makes it three dimensional.

A list does not contain any _____ rows.

From a list of customers living in the North,the South,the East,and the West,in order to get specific information to create a list of all customers living in the North,the _____ function must be used.

The _____ quickly creates smaller lists out of a much larger list.

By creating a two-dimensional pivot table in Excel,using rows and columns,you can build a data warehouse.

The purpose of the AutoFilter function is to help you quickly focus on only the information that is important by _____ the information that is not.

In using Goal Seek to compute an unknown value,the first step is to click on the "Value Fields" setting,then click on "Summarize Values By",and then select "Goal Seek".

In a list,each column has only _____ type(s)of information.

A(n)_____ is a collection of information arranged in columns and rows in which each column displays one particular type of information.

A(n)_____ is a description of a list by column.

A list is a collection of information arranged in _ and _ in which each column displays one particular type of information.

_____ is Microsoft's spreadsheet software that allows you to work with and analyze information.

A pivot table can be created for information obtained from a Word or Access table.

The first _____ in a list contains column headings or labels.

The default location of a pivot table is to place it in the same worksheet as that of the list.

A pivot table can be two-or three-dimensional.

A(n)_____ is the intersection of a row and column.

Goal Seek works backward from an objective to compute an unknown value.

To use Goal Seek,one has to create a worksheet that includes an objective based on some unknown value in a cell.