DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Calculate the average of numerical data using the following functions:
|
|
AVERAGE
|
|
|
MIN
|
|
|
MAX
|
|
|
SUM
|
|
|
VLOOKUP
|
Explanation:
Detailed explanation-1: -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-2: -Python Average Average in Python is usually calculated by adding all the numbers in a list and then dividing it by the number of elements in this list.
Detailed explanation-3: -There are three main types of average: mean, median and mode. Each of these techniques works slightly differently and often results in slightly different typical values. The mean is the most commonly used average. To get the mean value, you add up all the values and divide this total by the number of values.
There is 1 question to complete.