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. |