Exam 13: Decision Analysis With Spreadsheet Software

A shopkeeper wants to create a sublist of customers spending less than $50 and customers spending more than $100 per purchase,out of a list of all customer-purchase amounts.Which of the following combinations of values and Boolean operators must be chosen?

A list contains the names of members of a library,and the date of their joining.Which of the following can be achieved using conditional formatting?

Using spreadsheet software,a company creates a list of its customers with the following columns: customer's date of birth,customer location,and date of latest purchase.If the company needs to find the exact number of individuals to whom birthday wishes would need to be sent on a particular day,which function should it use?

The basic AutoFilter function creates _____ based on exact match criteria.

A(n)_____ takes the most steps to create,but yields highly valuable summary information.

A _____ is a description of a list by column.

By creating a two-dimensional pivot table in Excel,using rows and columns,you can build a data warehouse.

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 "To value" field in the Goal Seek Dialog box?

_____ is an Excel function which allows you to view the entire list while having certain information called to your attention.

Which of the following is a characteristic that a list must possess?

A list definition table is a list of columns in a workbook with their descriptions.

If you had a listing of customer information and you need to quickly group and summarize this information,which spreadsheet feature would you use?

To highlight information that meets some criterion that you set,you could use _____ formatting.

In the _____ area of a summary of a pivot table,you drop the fields of information that you want in the interior of the pivot table.

If you wanted to see a list of every student who scored greater than 85 percent on a test,you would use the Custom AutoFilter function.

Should a spreadsheet list contain any blank rows?

In a list,each column has only _____ type(s)of information.