User talk:Abbygale536
Appearance
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)