USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Average
|
|
|
Min
|
|
|
Max
|
|
|
Count
|
Detailed explanation-1: -The function uses the following arguments: Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average. Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average.
Detailed explanation-2: -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 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-4: -Average This 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-5: -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.