DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Use a function to calculate the average of the Movie Scores column.
|
|
=AVERAGE
|
|
|
=AVERAGEIF
|
|
|
=SUM
|
|
|
=SUMIF
|
Explanation:
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: -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.
There is 1 question to complete.