USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=AVERAGE
|
|
|
=AVERAGEIF
|
|
|
=SUM
|
|
|
=SUMIF
|
Detailed explanation-1: -AVERAGE function-calculate an average of numbers You use the Excel AVERAGE function to get an average of all numbers in the specified cells or ranges.
Detailed explanation-2: -Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-3: -Click the cell to the right of a row or below a column. Then, on the HOME tab, click the AutoSum down arrow, click Average, verify the formula if what you want, and press Enter. When I double-click inside the cell, I see it is a formula with the AVERAGE function.
Detailed explanation-4: -An average test score is the sum of all the scores on an assessment divided by the number of test-takers. For example, if three students took a test and received scores of 69, 87, and 92, these numbers would be added together and then divided by three to get an average of 82.6.