Scribd Logo
Upload

Welcome to Scribd!

  • 52 views

    Excel Lesson 5: Using Functions

    Uploaded by

    john
    This document discusses functions in Excel. It defines what functions are and their key parts. It describes how to enter formulas with functions and the different types of functions - mathematical, statistical, financial, logical, and text functions. It provides examples of commonly used functions in each category.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Excel Lesson 5: Using Functions

    Uploaded by

    john
    52 views21 pages
    This document discusses functions in Excel. It defines what functions are and their key parts. It describes how to enter formulas with functions and the different types of functions - mathematical, statistical, financial, logical, and text functions. It provides examples of commonly used functions in each category.

    Original Title

    ExcelLesson05

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses functions in Excel. It defines what functions are and their key parts. It describes how to enter formulas with functions and the different types of functions - mathematical, statistical, financial, logical, and text functions. It provides examples of commonly used functions in each category.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    52 views21 pages

    Excel Lesson 5: Using Functions

    Uploaded by

    john
    This document discusses functions in Excel. It defines what functions are and their key parts. It describes how to enter formulas with functions and the different types of functions - mathematical, statistical, financial, logical, and text functions. It provides examples of commonly used functions in each category.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 21

    Excel Lesson 5

    Using Functions

    Microsoft Office 2010


    Introductory

    1 Pasewark & Pasewark


    Objectives

    ⚫ Identify the parts of a function.


    ⚫ Enter formulas with functions.
    ⚫ Use functions to solve mathematical
    Excel Lesson 5

    problems.
    ⚫ Use functions to solve statistical problems.
    ⚫ Use functions to solve financial problems.

    2 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Objectives (continued)

    ⚫ Use logical functions to make decisions with


    worksheet data.
    ⚫ Use functions to insert times and dates in a
    Excel Lesson 5

    worksheet.
    ⚫ Use text functions to format and display cell
    contents.

    3 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Vocabulary

    ⚫ argument ⚫ logical functions


    ⚫ date and time functions ⚫ mathematical functions
    ⚫ financial functions ⚫ statistical functions
    Excel Lesson 5

    ⚫ Formula AutoComplete ⚫ text functions


    ⚫ function ⚫ trigonometric functions

    4 Pasewark & Pasewark Microsoft Office 2010 Introductory


    What Are Functions?

    ⚫ A function is a shorthand way to write an


    equation that performs a calculation.
    ⚫ A formula with a function has three parts:
    Excel Lesson 5

    – The equal sign identifies the cell contents as a


    formula.
    – The function name identifies the operation to be
    performed.
    – The argument is the value the function uses to
    perform a calculation.
    5 Pasewark & Pasewark Microsoft Office 2010 Introductory
    What Are Functions? (continued)

    ⚫ Parts of a function
    Excel Lesson 5

    6 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Entering Formulas with Functions

    ⚫ To enter a formula with a function, you need


    to do the following.
    – Start the formula with an equal sign.
    Excel Lesson 5

    – Select or enter the function you want to use.


    – Select or enter the arguments.
    – Enter the completed formula.
    ⚫ To open the Insert Function dialog box, click
    the Insert Function button on the Formula
    Bar.
    7 Pasewark & Pasewark Microsoft Office 2010 Introductory
    Entering Formulas with Functions
    (continued)

    ⚫ Insert Function dialog box


    Excel Lesson 5

    8 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Entering Formulas with Functions
    (continued)

    ⚫ You can also enter a formula with a function


    directly in a cell by typing an equal sign, the
    function name, and the argument.
    Excel Lesson 5

    ⚫ Formula AutoComplete helps you enter a


    formula with a valid function name and
    arguments.
    – As you begin to type the function name, a list of
    function names appears below the active cell.

    9 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions

    ⚫ Mathematical functions and trigonometric


    functions manipulate quantitative data in a
    worksheet.
    Excel Lesson 5

    ⚫ Some mathematical operations, such as


    addition and subtraction, do not require
    functions.
    ⚫ Mathematical and trigonometric functions are
    particularly useful when you need to
    determine values such as logarithms,
    factorials, and sines.
    10 Pasewark & Pasewark Microsoft Office 2010 Introductory
    Types of Functions (continued)

    ⚫ Commonly used mathematical and trigonometric


    functions
    Excel Lesson 5

    11 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Statistical functions are used to describe


    quantities of data.
    ⚫ For example, statistical functions can
    Excel Lesson 5

    determine:
    – the average, standard deviation, or variance of a
    range of data.
    – the number of values in a range, the largest value
    in a range, and the smallest value in a range.

    12 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Commonly used statistical functions


    Excel Lesson 5

    13 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Financial functions are used to analyze


    loans and investments.
    ⚫ Some commonly used financial functions are
    Excel Lesson 5

    future value, present value, and payment.

    14 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Commonly used financial functions


    Excel Lesson 5

    15 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Logical functions, such as the IF function,


    display text or values if certain conditions exist.
    – The first argument sets a condition for comparison,
    called a logical test. The second argument determines
    Excel Lesson 5

    the value if the logical test is true. The third argument


    determines the value if the logical test is false.
    ⚫ For example, the formula
    =IF(C4>60,“PASS”,“FAIL”) returns PASS if the
    value in cell C4 is greater than 60; otherwise the
    formula returns FAIL.
    16 Pasewark & Pasewark Microsoft Office 2010 Introductory
    Types of Functions (continued)

    ⚫ Commonly used logical functions


    Excel Lesson 5

    17 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Date and Time functions can also be used


    to insert dates and times in a worksheet.
    Excel Lesson 5

    18 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Types of Functions (continued)

    ⚫ Text functions are used to format and


    display cell contents.
    Excel Lesson 5

    19 Pasewark & Pasewark Microsoft Office 2010 Introductory


    Summary

    In this lesson, you learned:


    ⚫ A function is a shorthand way to write an equation that
    performs a calculation. A formula with a function has
    Excel Lesson 5

    three parts: an equal sign, a function name, and for


    most functions one argument, which acts as an
    operand.
    ⚫ The best way to select a function is from the Insert
    Function dialog box. The Function Arguments dialog
    box provides a description of each argument you
    enter for the function.
    20 Pasewark & Pasewark Microsoft Office 2010 Introductory
    Summary (continued)

    ⚫ When you type a formula with a function directly in a


    worksheet cell, Formula AutoComplete helps you enter
    a formula with a valid function name and arguments.
    ⚫ Functions can be used to perform mathematical,
    Excel Lesson 5

    statistical, financial, and logical operations. They can


    also be used to insert and calculate dates and times and
    to format text.

    21 Pasewark & Pasewark Microsoft Office 2010 Introductory

    You might also like