Exam 13: Decision Analysis With Spreadsheet Software

When you drop information into the "Values" area in the lower-right corner of the skeletal structure of a pivot table,the default aggregation of summarization is ____.

A worksheet,created by a company making toothbrushes,contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10),Sale price * number of toothbrushes sold (K11),Transportation cost per toothbrush * number of toothbrushes sold (K12),the fixed cost (K13)involved in manufacturing the toothbrushes,and the net profit (K14).If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000,what must they enter in the "For set" field in the Goal Seek Dialog box?

If you wanted customers who earned an annual income of less than $25,000 to appear in red,what spreadsheet feature would you use?

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

The _____ allows you to view rows in a list that meet a range of criterion that you specify.

The Filter function filters a list and allows you to hide all the rows in a list except those that match criteria you specify.

The basic Filter function allows you to use other criteria such as greater than,less than,and so on to hide rows not meeting specific criteria.

Using spreadsheet software,a manager makes a list of the number of employees in each department in his company.The team size column has the following entries in each cell: 3,3,7,13,22,15,26,4.If the manager uses a basic Filter,which of the following can he accomplish?

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

_____ is an Excel function that works backward from an objective to compute an unknown value.

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 company uses Excel to maintain a list of its customers.It maintains details of customer name,id,age,and region of residence (East,West,North,and South).If a manager wants a list of only those customers living in the North,which of the following functions of Excel can the manager use?

A worksheet,created by a company making toothbrushes,contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10),Sale price * number of toothbrushes sold (K11),Transportation cost per toothbrush * number of toothbrushes sold (K12),the fixed cost (K13)involved in manufacturing the toothbrushes,and the net profit (K14).If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000,what must they enter in the "By changing cell" in the Goal Seek Dialog box?

The basic Filter function can only be used to sort numeric data.

When creating a ____,you create dimensions of information by specifying how information is to be summarized by dimension.

If you wanted to see a sublist of every student whose last name begins with "B" from a list of all students,you could use the basic Filter function.

A list maintained by doctors at a hospital contains the following patient information columns: registration number,name,age,height,weight,and date of admission.What information can be obtained by using the basic Filter function of Excel?

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 is created dividing the customers based on their location.Where must the "mode of payment" field be dropped if information on mode of payment based on region is required?

The Filter function _____ the information you want to see by hiding the information you do not want to see.

A cell is the intersection of a column and a row.