Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Spreadsheet Functions

    Uploaded by

    Ashanie Gordon
    The document discusses spreadsheet formulas and functions. It provides examples of common arithmetic formulas like addition, subtraction, multiplication and division. It also explains functions like SUM, AVERAGE, MAX, MIN, COUNT, COUNTIF, VLOOKUP and IF that are used to manipulate and analyze data in spreadsheets.

    Copyright:

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

    Spreadsheet Functions

    Uploaded by

    Ashanie Gordon
    15 views3 pages
    The document discusses spreadsheet formulas and functions. It provides examples of common arithmetic formulas like addition, subtraction, multiplication and division. It also explains functions like SUM, AVERAGE, MAX, MIN, COUNT, COUNTIF, VLOOKUP and IF that are used to manipulate and analyze data in spreadsheets.

    Original Description:

    Functions in spreadsheet

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses spreadsheet formulas and functions. It provides examples of common arithmetic formulas like addition, subtraction, multiplication and division. It also explains functions like SUM, AVERAGE, MAX, MIN, COUNT, COUNTIF, VLOOKUP and IF that are used to manipulate and analyze data in spreadsheets.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    15 views3 pages

    Spreadsheet Functions

    Uploaded by

    Ashanie Gordon
    The document discusses spreadsheet formulas and functions. It provides examples of common arithmetic formulas like addition, subtraction, multiplication and division. It also explains functions like SUM, AVERAGE, MAX, MIN, COUNT, COUNTIF, VLOOKUP and IF that are used to manipulate and analyze data in spreadsheets.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Information Technology

    Spreadsheet Functions and Formulas

    What is a Formula?
    Formula – A formula is spreadsheet calculation in which a mathematical operator is used to
    obtain a result.

    Advanced Arithmetic Formulas

    ✔ Addition
    Cell A1 + Cell B1 + Cell C1 is entered into Excel as =A1+B1+C1

    ✔ Subtraction
    Cell A1 - Cell B1 is entered into Excel as =A1-B1

    ✔ Multiplication
    Cell A1 x Cell B1 x Cell C1 is entered into Excel as =A1*B1*C1

    ✔ Division
    Cell A1 ÷ Cell B1 is entered into Excel as =A1/B1

    ✔ Brackets
    Brackets are used for using multiple arithmetic operators in the same cell. Brackets are always
    resolved first, then the rest of the calculation.
    Cell [A3 x Cell A1] ÷ [Cell B1+Cell C1] is entered into Excel as =(A3*A1) /(B1+C1)

    ✔ Square Root
    Used to find the root of a number =SQRT (number)

    ✔ Power
    =POWER (Number, Power) e.g., = POWER (5,2) is the equivalent of 5, 2
    What is a Function ?
    Function – A Function is a named operation built into the spreadsheet to manipulate data
    (numerical and otherwise).

    ✔ Sum
    = SUM (value to be added separated by commas /cell range/ addresses) This is used to give a
    total for some values entered. For example, = SUM (A2:A10)

    ✔ Average
    = AVERAGE (value to be averaged separated by commas /cell range/ addresses) This is used to
    give an average of the values entered. =AVERAGE (A2:A10)

    ✔ Date
    = DATE (YYYY, MM, DD) Used for entering dates or date ranges

    ✔ Max
    = MAX (value to be compared separated by commas /cell range/ addresses) Returns the largest
    value found in the range, ignores logical errors. For example =MAX (A2:A10)

    ✔ Min
    = MIN (value to be compared separated by commas /cell range/ addresses) Returns the smallest
    value found in the range, ignores logical errors. For example, =MIN (A2:A10)

    ✔ Count
    = COUNT (values to be counted separated by commas /cell range/ addresses) Counts the number
    of cells in a range or numbers contained in its brackets. For example, =COUNT (A2:A10)

    ✔ COUNTIF
    Counts the number of cells that meet the given criteria. For example , =COUNTIF(D1:D30,”A)
    In this example , Cells D1 to D30 have exams grades . To find out how many students got
    grade A, you could use the COUNTIF function.

    ✔ VLOOKUP
    =VLOOKUP (Lookup Value, Table Array, Column to be returned if a value is
    found, Range) Used to retrieve information in an excel spreadsheet based on some criteria for
    example. For example, =VLOOKUP (B3, MARKS,2) Suppose B3 contained the number 87,
    and MARKS was 10 rows of data containing marks and a letter grade. The lookup function
    would search the first column of marks and the number 87, if found it would go to the
    second column ( the 2 in the function ) , and return the grade corresponding to that
    number.

    ✔ IF
    Spreadsheet makes a choice depending on what it finds. It returns one of two values depending
    on the condition that you set. For example =IF (D1<=2, “ASK MUM FO9R A LOAN”,”
    MONEY OK”). In this example , cell D1 contains a formula showing how much pocket
    money you have left. If D! is less than or equal to $2 , then ‘Ask mum for a loan’, is
    displayed . If you have more than $2, then money ok is displayed.

    You might also like