click below
click below
Normal Size Small Size show me how
Excel Lesson 5
| Question | Answer |
|---|---|
| Autosum | Calculates the total from the adjacent cell up to the first non numeric cell, using the SUM punctuation in its formula. |
| Average function | Adds a range of cells and then divides by the number of cell entries, determining the mean value of all values in the range. |
| Count function | Determines how many cells in a range contain a number. |
| Counta function | Counts all non blank entries in a range, whether they include text or numbers. |
| Countblank function | Counts the number of blank cells in a range. |
| Function | Provides an easy way to perform mathematical work on a range of cells, quickly and conveniently. |
| Max function | Returns the largest value in a set of values. |
| Merged cells | Combines two or more cells into a single cell. |
| Min function | Allows you to determine the minimum value in a range of cells. |
| Sum function | Totals all of the cells in a range, easily and accurately. |