FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The COUNTIFS Function[1] is categorized under Excel Statistical functions. COUNTIFS will count the number of cells that meet a single criterion or multiple criteria in the same or different ranges.

Detailed explanation-2: -The AVERAGEIF function calculates the average ignoring the blank cells. But it can calculate the average of blank cells, whereas the AVERAGEIFS function can calculate the average either for the blank cells or ignoring the blank cells.

Detailed explanation-3: -Countifs are one of the most used statistical functions in Excel. The COUNTIFS function applies one or more conditions to the cells in the given range and returns only those cells that fulfill all of the conditions.

Detailed explanation-4: -Statistical functions are used when a mathematical process is required for a range of cells, such as summing the values in several cell locations. For these computations, functions are preferable to formulas because adding many cell locations one at a time to a formula can be very time-consuming.