USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Values
|
|
|
Formulas
|
|
|
Labels
|
|
|
Functions
|
Detailed explanation-1: -Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
Detailed explanation-2: -Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.
Detailed explanation-3: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-4: -The STANDARDIZE Function[1] is available under Excel Statistical functions. It will return a normalized value (z-score) based on the mean and standard deviation. A z-score, or standard score, is used for standardizing scores on the same scale by dividing a score’s deviation by the standard deviation in a data set.