User talk:Abbygale536

Excel Formulas
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)