FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
COUNTIF is a Statistical function that uses criteria to count the number of items in a range.
A
T
B
F
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -What is the COUNTIFS Function? 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: -What is the COUNTIF Function? The COUNTIF Function[1] will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions. In financial analysis, the COUNTIF function is quite helpful.

Detailed explanation-3: -COUNTIF requires a range, you can’t substitute an array. COUNTIF returns incorrect results when used to match strings longer than 255 characters. COUNTIF will return a #VALUE error when referencing another workbook that is closed.

Detailed explanation-4: -Up to 127 range/criteria pairs are allowed.

There is 1 question to complete.
Previous
Next