click below
click below
Normal Size Small Size show me how
Computer AppsII
NLREast Campus Computer Apps-Excel Lesson 5 Functions
| Question | Answer |
|---|---|
| AVERAGE | Displays the average of the range identified in the argument |
| COUNT | Displays the number of cells with numerical values in the argument range |
| MAX | Displays the largest number contained in the range identified in the argument. |
| MIN | Displays the smallest number contained in the range identified in the argument. |
| STDEV | Displays the standard deviation of the numbers contained in the range of the argument. |
| VAR | Displays the variance for the numbers contained in the range of the argument. |
| SQRT | Displays the square root of the number identified in the argument |
| ROUND | Displays the rounded value of a number to the number of places designated by the second argument. |
| LN | Displays the natural logarithm of a number. |
| DATE | Displays the date in a variety of formats |
| NOW() | Displays the current date or time based on the computer's clock. For example, =NOW() in a cell will display the current date and time, such as 5/23/07 10:05. |
| REPT | Displays the text (first argument) a specified number of times (second argument). For example, REPT(B6,3) will repeat the text in cell B6 three times. |