USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Logical
|
|
|
Lookup & Reference
|
|
|
Statistical
|
|
|
Text
|
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 COUNTIF function is a premade function in Excel, which counts cells as specified. NOTE: The COUNTIF function can have basic or more advanced uses. This covers the basic use for how to count specific numbers and words. Numbers (e.g. 90) and words (e.g. “Water") can be specified.
Detailed explanation-3: -The difference is that COUNTIF is designed for counting cells with a single condition in one range, whereas COUNTIFS can evaluate different criteria in the same or in different ranges.
Detailed explanation-4: -Note: The AVERAGEIFS function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.