All Exams Test series for 1 year @ ₹349 only
Question

Which function returns the smallest value?

The correct answer is

MIN()

In MS Excel, the MIN() function returns the smallest numerical value in a range.

Syntax: =MIN(number1, [number2], ...)

Example: =MIN(5, 3, 8, 1, 9) returns 1.

Related functions: MAX() returns the largest value; AVERAGE() returns the mean; SUM() returns the total.

Was this answer helpful?

Similar Questions

  1. You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?

  2. What file extension is used to save an MS PowerPoint 2021 presentation?

  3. If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?

  4. Which function returns the smallest value?

  5. You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?

  6. If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?

  7. What file extension is used to save an MS PowerPoint 2021 presentation?

  8. Which function returns the smallest value?

  9. You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?

  10. If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?


Important Questions from Microsoft Office

  1. Considering the content of the first cell of a worksheet as 10, the value of the Excel formula = $A$1/4 is:

  2. In MS-PowerPoint, slide show options available to the presenter include all of the following, except for:

  3. In a spreadsheet, one function inside another is called:

  4. Which of the following alignment is applied to the below text?

    [Type a quote from the document or the

    summary of an interesting point. You can

    position the text box anywhere in the

    document. Use the Text Box Tolls tab to

    change the formatting of the pull quote text

    box.]

  5. In MS Excel, the cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is:

Need Expert Advice?
Test Series
RRB JE img
Railways
RRB JE (CBT 1 + CBT 2) 2026 Mock Test Series
1515 Tests 19 Tests Free
1643 Attempts
4.3(155)
English, Hindi

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App