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

https://brainmass.com/computer-science/algorithms/microsoft-excel-worksheet-function-60081

#### 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