Exam 13: Decision Analysis With Spreadsheet Software

A company makes a list of its customers using spreadsheet software.It has four columns containing information on customer id (4-Digit),customer name,date of most recent purchase,and address respectively.Which of the following represents information stored in the third column of the list?

_____ highlights the information in a cell that meets some criteria you specify.

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.

A column in a list can display many different types of information.

The first row in a list usually contains labels or row headings.

A pivot table enables you to group and summarize information.

A list contains information displayed only in columns whereas a pivot table has information in both rows and columns.

The default aggregation or summarization in a pivot table is by ____.

The _____ function allows you to use criteria such as greater than,less than,and so on,to create a sublist of required elements.

The Custom Filter function allows you to hide all the rows in a list except those that fit into a range of numbers.

A three-dimensional pivot table has rows,columns,and ____.

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

A pediatrician creates a list,using spreadsheet software,of the ages of all the children who had come to him suffering from acute pneumonia.If the doctor wants to find the number of children aged 3 who had had pneumonia,from the list,he must click on a cell in the list,click on Data (from the menu bar),and click on Filter.Subsequently,he must:

_____ highlights the information in a cell that meets some criteria you specify.

The basic AutoFilter function allows you to create sublists using _____ match criteria.

Conditional formatting only works for textual data.

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

If you cannot create a list,then you probably cannot create a list definition table.

The Custom Filter function can create a sublist of people aged 45 and above from a list of people of varying ages.

Which of the following enables you to group and summarize information?