Jump to content

User talk:Abbygale536

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Excel Formulas

[edit]

Microsoft Excel is a computer program created and designed by Microsoft Word. The program is a spreadsheet application used to monitor numeric information.

Excel offers numerous shortcuts and formulas to quickly analyze data. Some commonly used formulas include:

1. sum: The sum function is used to add two or more values.

    steps:
         a) press: = 
         b) type: sum
         c) press: (
         d) type numeric value
         e) press: +
         f) type numeric value
         g) press: )
         h) press: enter
    example:
         =sum(8+1)

2. count: The count function is used to count the amount of numeric values present.

    steps:
         a) press: = 
         b) type: count
         c) press: (
         d) select a range of cells
         g) press: )
         h) press: enter
    example:
         =count(e4:e8)

3. max: The max function is used to find the numerically largest value present.

    steps:
         a) press: = 
         b) type: max
         c) press: (
         d) select a range of cells
         g) press: )
         h) press: enter
    example:
         =max(e4:e8)

4. min: The min function is used to find the numerically smallest value present.

    steps:
         a) press: = 
         b) type: min
         c) press: (
         d) select a range of cells
         g) press: )
         h) press: enter
    example:
         =min(e4:e8)

5. countblank: The countblank function is used to find the amount of blank cells present.

    steps:
         a) press: = 
         b) type: countblank
         c) press: (
         d) select a range of cells
         g) press: )
         h) press: enter
    example:
         =countblank(e4:e8)