Question

A store employee has a spreadsheet of the power tools he sells in Column A and their corresponding prices in Column B. In cell C1, would like to display the price of the power tool with the cheapest price. Which spreadsheet function should he use?

Answer 1

Answer:

Excel MIN Function

Explanation:

Excel MIN Function is used to get the smallest value which means, it returns the smallest value in the array(a set of data).

syntax is =MIN (number1, [number2], ...)