FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function used to calculate the average of numerical data
A
SUM
B
MAX
C
MIN
D
AVERAGE
Explanation: 

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: -The statistics.mean() function is used to calculate the mean/average of input values or data set.

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.