Explore BrainMass

Explore BrainMass

    Microsoft Excel Worksheet Function

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Select the worksheet function that will return the largest number in a specified range of cells, the function should ignore text and logical values.

    Select the worksheet function that will return the smallest number (including numbers, logical values, and text,) in a specified range of cells

    These are the functions to pick from:
    Sum, average, if, hyperlink, count, max, sin, sum if, pmt, stdev

    How do u move a selected cell (1) to another cell(10) without using the cut, copy, or paste commands?

    Using the IF function, type a formula that will display the word "yes" in a cell if the value in cell F5 (325) is less than F6 (350) and no if it is not. I cant use spaces in the formula?

    Type the formula that will subtract the contents of cell G15 (445) from the cells of I5 through I10
    I5 1040
    I6 2840
    I7 5180
    I8 430
    I9 884
    I10 2670

    © BrainMass Inc. brainmass.com December 24, 2021, 5:38 pm ad1c9bdddf
    https://brainmass.com/computer-science/algorithms/microsoft-excel-worksheet-function-60081

    Attachments

    Solution Preview

    Some Questions about Using Microsoft Excel

    Select the worksheet function that will return the largest number in a specified range of cells, the function should ignore text and logical values.
    MIN

    Select the worksheet function that will return the smallest ...

    Solution Summary

    The expert examines Microsoft Excel worksheet functions.

    $2.49

    ADVERTISEMENT