Which Excel function counts the number of empty cells in specified range, which is its only argument?
कौन-सा एक्सेल फंक्शन तर्क में दी गई खाली सेल की संख्या की गणना करता है?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. COUNTBLANK
Explanation
COUNTBLANK(range) counts the empty cells in a range. COUNT counts cells with numbers, COUNTA counts non-empty cells, and COUNTB does not exist.
COUNTBLANK(range) रेंज की खाली सेल गिनता है। COUNT संख्या वाली सेल, COUNTA भरी हुई सेल गिनता है; COUNTB कोई फंक्शन नहीं है।
More Office Automation (MS Office) questions
- SUM function can be quickly entered in a cell by pressing ....... in Excel.
- In the page setup dialog box, following option(s) are available for orientation :
- What is/are the primary functions to look up the information stored in a list or table in Excel?
- .............. allows you to alter all the slides in the presentation.
- ............ is a drawing object which is usually printed as the background of text on all the pages of document.
- If data is organized in rows, which function is used to search a value ?