USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
AVERAGE
|
|
SUM
|
|
POWER
|
|
MEDIAN
|
Detailed explanation-1: -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-2: -AutoSum lets you find the average in a column or row of numbers where there are no blank cells. 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-3: -To find the mean in Excel, you start by typing the syntax =AVERAGE or select AVERAGE from the formula dropdown menu. Then, you select which cells will be included in the calculation. For example: Say you will be calculating the mean for column A, rows two through 20. Your formula will look like this: =AVERAGE(A2:A20).
Detailed explanation-4: -Use the COUNT function to count cell locations with numerical values. Use the AVERAGE function to calculate the arithmetic mean.