Microsoft Excel Interview Questions and Answers
Question: What is the difference among COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel?Answer:COUNT: COUNT is used to count cells containing numbers, dates, etc. any value stored as number excluding blanks. COUNTA: COUNTAor Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks. COUNTBLANK: It counts blank cells or cells with an empty string. COUNTIF and COUNTIFS: These count cells matching a certain criteria. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?