Microsoft excel worksheet function


Question:

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

Solution Preview :

Prepared by a verified Expert
Database Management System: Microsoft excel worksheet function
Reference No:- TGS01937485

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)