FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which function should be used to calculate the smallest number in a range of cells?

A	max
B	sum
C	avg
D	min

Explanation:

Detailed explanation-1: -The MIN function in Excel is used to find the smallest value in a given range of cells. For example, if you have a list of numbers and you want to find the smallest number in that list, you can use the MIN function to do so.

Detailed explanation-2: -Returns the smallest number in a set of values.

Detailed explanation-3: -The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data.

Detailed explanation-4: -Essentially, it calculates and returns the k smallest value in a dataset. In financial analysis, the SMALL function can be useful in finding the smallest value in a given set of values.

There is 1 question to complete.