Question

A manufacturer of machine tools creates a spreadsheet of cutting tools and their costs. The spreadsheet has four fields: name of the cutting tool, cost per cutting tool, number of cutting tools, and total cost. If you want to find out which cutting tool costs the most, how would you sort the data?

A) Sort the data in descending order of cost per cutting tool
B) Sort the data in ascending order of cost per cutting tool
C) Sort the data in the field "number of cutting tools" in ascending order
D) Sort the data in the field "name of the cutting tool" in ascending order

Answer 1

To find out which cutting tool costs the most, sort the data in descending order of cost per cutting tool. This will place the most expensive cutting tool per unit at the top of the list.

Step-by-step explanation:

To determine which cutting tool costs the most, you would sort the data in descending order of cost per cutting tool (A). By doing this, the cutting tool with the highest cost per unit will appear at the top of the list. Sorting by factors such as the name of the cutting tool or the number of cutting tools won't give you the necessary information directly, since these don't reflect the individual cost of the tools.

In order to find out which cutting tool costs the most, you would sort the data using the field 'cost per cutting tool'. To do this, you would sort the data in descending order of cost per cutting tool. This means that the cutting tool with the highest cost per unit would be listed first.