Purchase Solution

Microsoft Excel Worksheet Function

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

The expert examines Microsoft Excel worksheet functions.

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

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

View More Free Quizzes
Related BrainMass Solutions

  • Microsoft Excel

    55467 Microsoft Excel True or false questions 1. All functions use a range of cells for the argument. There are no single cell referenced formulas? 2. When Excel calculates averages, blank cells or cells containing text are ignored? 3.

  • Financial Analysis with Microsoft Excel

    The solution discusses the financial analysis with microsoft Excel.

  • Excel spreadsheet:Election 2000

    Regards This posting shows the procedure to make different types of calculations and use of different functions in Microsoft excel.

  • Microsoft Excel Workbook

    55475 Microsoft Excel 13. A new workbook will initially contain only three worksheets; more can be added later if needed. 14. If you inadvertently delete a worksheet, you can restore it by clicking the Undo button 15.

  • Budget in Excel

    Project Details Open Microsoft Excel 2007. You will begin with a new worksheet. Step 1: Create and format a row to show the months for the year (Jan-Dec).

  • Decision Models using Excel

    You should turn in an Excel file with each problem on a separate worksheet. Label each worksheet in the file with the problem number (i.e. 3.3.1, 3.3.2, etc.) see attached file. Decision Models using Excel

  • Microsoft excel

    55544 Microsoft excel Predefined formatting attributes that can be applied to a cell are called?

  • Statistical Choices Worksheet and SPSS or Excel Analysis

    This is the data for Study #2 introduced in the Statistical Choices worksheet in the zip file. â?¢ Analyze the data using SPSS or Excel based on the purpose of the study. â?¢ Copy and paste the results into a Microsoft® Word document. â?

  • VB.NET to Excel

    The first step is to create a reference in our project to Microsoft Excel 11.0 Objects Library (COM reference).

View More Related Solutions