NLREast Campus Computer Apps-Excel Lesson 5 Functions
Help!
|
|
||||
|---|---|---|---|---|---|
| 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.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
smills01
Popular Computers sets