Exam 13: Decision Analysis With Spreadsheet Software

In the skeletal structure of a pivot table,the _____ is the list of fields in the original table that you can work with.

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.

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

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

Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?

When using the basic Filter,you are limited to working with just one column or category of information.

If you were searching for a particular customer in a list and you knew,for instance,the state the customer lived in,what spreadsheet feature should you use?

Conditional formatting highlights the information in a cell that does not meet the criteria you specified.

A list is created by the sales manager of a firm,listing the number of sales per week for the current financial quarter.The column for number of sales per week is as follows: 25,37,34,56,44,26,35,35,37.The sales manager wants to find the number of weeks where sales was above 37.Using Excel,he clicks on a cell in the list,on Data (from the menu bar),and on Filter.Subsequently,he clicks on the list box arrow next to the Sales/week column and selects 37.What will his answer be?

A list often contains blank rows to separate groups from other groups.

Goal Seek works backward from an objective to compute a(n)_____ value.

Conditional formatting from a list can be removed only from selected cells.

What is the difference between a Filter and a pivot table?

Basic Filter allows you to choose to view only the information that you want;all other information can be hidden.

Which spreadsheet feature would allow one to find the total number of customers in a certain region from a list containing details of all the customers of a company?

A newly formed company producing glass paperweights creates a worksheet using Excel for finding the number of units it has to sell to post a profit of $10,000 in the first year.In the Goal Seek tool dialog box,where must the required profit be entered?

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

_____ allows you to hide all the rows in a list except those that match criteria,besides "is equal to," you specify.

A list often contains blank columns to separate categories from other categories.

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 and "Lesser Than" 75 as his criteria.How many students will be selected?