Exam 13: Decision Analysis With Spreadsheet Software

The Custom Filter function allows you to hide all the rows in a list except those that match criteria,besides "_____," you specify.

Which of the following is true of lists?

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

A list containing customer and customer purchase information has the following columns: customer name,location (of the customer,i.e. ,North,South,East,and West),customer income,customer age,and mode of payment during last purchase (cash or card).A pivot table to find the number of customers in each location and containing age,income,and purchase information of customers needs to be created.Where must the "location" field be dropped in the pivot table skeletal structure to create such a table?

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".

The PivotTable _____ is the list of fields in the original table that you can work with.

The results for a class of 10 after an examination are as follows: 56,59,64,76,78,49,62,79,86,94.A teacher creates a list of students and their marks using spreadsheet software.To find the number of students who scored between 65 and 75,he selects the Custom Filter function and enters "Greater Than" 65 or "Lesser Than" 75 as his criteria.How many students will be selected?

A list does not contain any _____ rows.

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

Which spreadsheet term defines a collection of information arranged in columns and rows?

Conditional formatting maintains the view of the _____ list of information but highlights key pieces of information that you are looking for.

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

Which of the following represents the steps for selecting the Goal Seek tool?

In a pivot table,the _____ area is where you will drop a field of information to create pages or layers.

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

A list consists of the following columns: customer id,customer income,total annual expenditure,and annual expenditure on food.While creating a pivot table,which of the following fields would require clicking on "Count" in the "Values" field setting?

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

Which of the following elements of the skeletal structure of a pivot table provides a three-dimensional aspect to the pivot table?

Which spreadsheet feature allows you to hide rows in a list?

Which of the following can be achieved using the conditional formatting function of Excel?