Share
Explore BrainMass

Microsoft Excel Worksheet Function

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

Attachments

Solution This solution is FREE courtesy of BrainMass!

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 number (including numbers, logical values, and text,) in a specified range of cells
MINA

How do u move a selected cell (1) to another cell(10) without using the cut, copy, or paste commands?
If you put the cursor at the border of cell 1, you will notice that a 4-pointed arrow system shows up. Click and hold down the button on the mouse. Move to where you want the cell contents to go and let go.

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 can't use spaces in the formula.
=IF(F5<F6,"yes","no")

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
=SUM(I5:I10)-G15