Question

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

Answer 1

The question above has multiple answers:

1.       Sort the data in the field "name of the tool" in ascending order alphabetically.

2.        Sort the data in the field “number of tools” in ascending order.

3.       Sort the data in ascending order of cost per tool.

4.       Sort the data in ascending order of total cost.

The answer is 3. Sort the data in ascending order of cost per tool

You can always make your spreadsheet work a bit more organized by sorting your data. In this case, what is required from the manufacturer of the tools is to sort the data so that someone else is able to find out which tool costs the most. Basically, the price of the tool which is the highest is required to be known. Therefore, the manufacturer of the tools should Sort the data in ascending order of cost per tool.