Scribd Logo
Upload

Welcome to Scribd!

  • 57 views

    Spreadsheets-An Introduction: Excel Functions (Cont.)

    Uploaded by

    swapnil sardar
    The document provides information about common Excel functions including MAX, MIN, and COUNT. It explains how to use each function by typing "=", the function name, opening and closing brackets, dragging the cell range, and pressing enter. It also discusses the elements of Excel formulas, including cell references, ranges, operators, and functions. Arithmetic operators like addition, subtraction, multiplication, and division are covered as well as comparison operators. Text concatenation using the ampersand operator and range and union reference operators are also summarized.

    Copyright:

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

    Spreadsheets-An Introduction: Excel Functions (Cont.)

    Uploaded by

    swapnil sardar
    57 views5 pages
    The document provides information about common Excel functions including MAX, MIN, and COUNT. It explains how to use each function by typing "=", the function name, opening and closing brackets, dragging the cell range, and pressing enter. It also discusses the elements of Excel formulas, including cell references, ranges, operators, and functions. Arithmetic operators like addition, subtraction, multiplication, and division are covered as well as comparison operators. Text concatenation using the ampersand operator and range and union reference operators are also summarized.

    Original Title

    ASM_92421

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides information about common Excel functions including MAX, MIN, and COUNT. It explains how to use each function by typing "=", the function name, opening and closing brackets, dragging the cell range, and pressing enter. It also discusses the elements of Excel formulas, including cell references, ranges, operators, and functions. Arithmetic operators like addition, subtraction, multiplication, and division are covered as well as comparison operators. Text concatenation using the ampersand operator and range and union reference operators are also summarized.

    Copyright:

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

    Spreadsheets-An Introduction: Excel Functions (Cont.)

    Uploaded by

    swapnil sardar
    The document provides information about common Excel functions including MAX, MIN, and COUNT. It explains how to use each function by typing "=", the function name, opening and closing brackets, dragging the cell range, and pressing enter. It also discusses the elements of Excel formulas, including cell references, ranges, operators, and functions. Arithmetic operators like addition, subtraction, multiplication, and division are covered as well as comparison operators. Text concatenation using the ampersand operator and range and union reference operators are also summarized.

    Copyright:

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

    SPREADSHEETS-AN INTRODUCTION

    EXCEL FUNCTIONS(CONT.)

    MAX
    The Excel MAX function returns the largest value from a supplied set of numeric values.
    To find the max:
    1.Type "=" sign in the cell in which you want to calculate the max.

    2.Type max, open brackets( ,drag the range from which you want to find the maximum, close bracket and press
    Enter.

    3.The maximum value will be displayed.

    MIN
    The Excel MIN function returns the smallest value from a supplied set of numeric values.
    To find the min:
    1.Type "=" sign in the cell in which you want to calculate the min.

    2.Type min, open brackets( ,drag the range from which you want to find the maximum, close bracket and press
    Enter.

    3.The minimum value will be displayed.


    COUNT
    The COUNT function counts the number of cells that contain numbers, and counts numbers within the
    list of arguments.
    To find the max:
    1.Type "=" sign in the cell in which you want to calculate the count.

    2.Type count, open brackets( ,drag the range from which you want to find the maximum, close bracket and press
    Enter.

    3.Thecount will be displayed.

    Elements of Microsoft Excel formulas


    When you make a formula in Excel, you can use different elements to supply the source data to the
    formula and indicate what operations should be performed on those data. Depending on the formula
    type that you create, it can include any or all of the following parts:
    Constants - numbers or text values that you enter directly in a formula, like =2*3.
    Cell references - reference to a cell containing the value you want to use in your Excel formula,
    e.g. =SUM(A1, A2, B5).
    To refer to data in two or more contiguous cells, use a range reference like A1:A5. For example, to sum
    values in all cell between A1 and A5, inclusive, use this formula:
    =SUM(A1:A5).
    Names - defined name for a cell range, constant, table, or function, for example =SUM(my_name).
    Functions - predefined formulas in Excel that perform calculations using the values supplied in their
    arguments.
    Operators - special symbols that specify the type of operation or calculation to be performed.
    After the equal sign, a formula includes the addresses of the cells whose values will be manipulated with
    appropriate operators placed in between. The operators are the standard arithmetic operators:

    Operator Meaning Example

    + Addition =A7+A9

    - Subtraction =A7-A9

    * Multiplication =A7*A9

    / Division =A7/A9

    ˆ Exponents =A7ˆA9

    For example, if you have an item price in cell A2 and VAT in cell B2, you can calculate the VAT amount by
    using the following percentage formula: =A2*B2

    REMEMBER: All formulas and functions must begin with a ’=’. ˆ The text of the formula or function will be
    displayed in the cell if you do not use an ’=’ and the calculation will not be executed.

    Operators in Excel worksheet formulas

    To tell Microsoft Excel what type of operation you want to perform in a formula, you use special symbols that are
    technically called operators. There exist 4 types of operators in Excel:

     Arithmetic - to perform basic mathematical operations.


     Comparison (logical) - to compare values.
     Concatenation - to join text values into a single string.
     Reference - to make rages and separate arguments in Excel functions.
    Arithmetic Operators
    These operators are used to perform basic mathematical operations such as addition, subtraction, multiplication,
    and division.

    Operator Meaning Formula example

    + (plus sign) Addition =A2+B2

    Subtraction =A2-B2
    - (minus sign)
    Negation (reversing the sign) =-A2 (changes the sign of the value in A2)

    * (asterisk) Multiplication =A2*B2

    / (forward slash) Division =A2/B2


    =A2*10%
    % (percent sign) Percentage
    (returns 10% of the value in A2)

    =A2^3
    ^ (caret) Exponential (power of)
    (raises the number in A2 to the power of 3)

    Text concatenation operator


    Text concatenation operator in Excel is the ampersand symbol (&). You can use it to join two or more text strings
    in a single string.
    For example, if you have country codes in column A and telephone numbers in column B, you can use the
    following formula to get the telephone numbers combined with the country codes:
    =A1&" "&B1
    In the above formula, we concatenate a space " " in between to make the numbers better readable:

    Reference Operators:
    The Excel Reference Operators are used when referring to ranges within a spreadsheet. The reference operators
    are:
    Operator Description

    : Range operator (defines a reference to a range of cells)


    , Union operator (combines two references into a single reference)
    “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references,
    including the cells written in the reference text, like: A11:A13
    “,” (comma) is the Union operator, which combines multiple Ranges into one reference, like A11:A13 , A11:C11

    Comparison/logical operators

    Condition Operator Formula Example

    Equal to = =A1=B1

    Not equal to <> =A1<>B1

    Greater than > =A1>B1


    Less than < =A1<B1

    Greater than or equal to >= =A1>=B1

    Less than or equal to <= =A1<=B1

    You might also like