Question

    In spreadsheet software, which formula can be used to

    find the largest value in a range of cells?
    A MIN() Correct Answer Incorrect Answer
    B MAX() Correct Answer Incorrect Answer
    C COUNT() Correct Answer Incorrect Answer
    D SUM() Correct Answer Incorrect Answer

    Solution

    The MAX() function in Excel or similar spreadsheet software identifies the largest value in a selected range of cells. Knowledge Booster: 1. MIN() finds the smallest value. 2. COUNT() counts the number of numeric entries. 3. SUM() adds the values in a range. 4. Use MAX() for data analysis, like finding peak sales.

    Practice Next

    Relevant for Exams: