Exam 13: Decision Analysis With Spreadsheet Software

When using the Filter function,you are not limited to working with just one ____.

Which of the following is an action which needs to be performed before using the Goal Seek tool?

A sociologist wants to know what percent of a town's population earns between $50,000 and $100,000 annually.He obtains an Excel sheet with income information for the town's population from the U.S Census Bureau.If he uses the Custom Filter function,which of the following values and Boolean operators must he enter and select respectively to obtain the required information?

A psychologist wants to find the prevalence of stress-related disorders in patients between the ages of 30 to 55.He creates a list of all of his patients aged 55 or below who came to him with symptoms of stress.Using Excel software's Custom Filter function,he clicks on the "Age" column arrow box,and selects Number Filters.Which of the following steps must he subsequently follow to answer his question?

A list is bordered on all sides by blank rows and columns;this space identifies the end of the list.

Microsoft Word is spreadsheet software that allows you to analyze any kind of information.

Which of the following spreadsheet features allows you to show only rows from a list that meets a specific condition?

The administration department of a university makes a list of the professors currently employed by the university (first column),the departments to which they belong (second column),and their ages (last column).Which of the following entries would most likely be contained in the fourth row of the third column?

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.Which of the following would result in the creation of a three-dimensional pivot table?

Regardless of how one uses the Filter function,Excel _____ rows that one does not want to see.

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

A two-dimensional pivot table with another layer giving it more depth is a _____ pivot table.

What is the intersection of a row and column in a spreadsheet called?

A list definition table:

If you wanted to see a list that displays all customers that have spent less than $20,or more than $100,in the past six months,you would use the Custom AutoFilter function.

In a list made using spreadsheet software,which of the following would be a label?

A biscuit manufacturer sells 10 packets of biscuits for $50.The cost involved in making 10 packets is $15,the cost of transporting 10 packets to the customers is $20,and the fixed costs involved amount to $5.If this information is put into a worksheet,what must one enter in the "To value" field of the Goal Seek dialog box to find the number of packets that need to be sold to make a profit of $200?

You need to have a(n)_____ before you can use a pivot table.

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

Entries in a list meeting some specific criteria can be identified using the Filter function or the conditional formatting function in Excel.