USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Answer. The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria. The AVERAGEIF function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.
Detailed explanation-2: -The AVERAGE function returns the mean value in a range of selected cells.
Detailed explanation-3: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-4: -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-5: -Description. Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.