Home

What does COUNTA () function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

Correct Answer : D.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

Also checkout these categories

Urinary Calculus Disease MCQ Surds and Indices MCQ Engineering Mechanics MCQ Additional Chemistry (Inorganic) MCQ Genetics MCQ Direct TAX MCQ Change of State MCQ General Science MCQ Botany MCQ Fungi and Lichens MCQ Angiosperms (Embryology Life Cycles) MCQ Boats and Streams MCQ

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..
You can do it
  1. How do you display current date and time in MS Excel?
  2. You can copy data or formulas
  3. Tab scroll buttons are place on Excel screen
  4. When you link data maintained in an excel workbook to a word document
  5. Which of the following action removes a sheet from workbook?
  6. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  7. How can you remove borders applied in cells?ACC
  8. Which of the following is not true regarding Conditional Formatting?
  9. Rounding errors can occur
  10. Which symbol must all formula begin with?
  11. The command Edit >> Fill Across Worksheet is active only when
  12. To edit in an embedded excel worksheet object in a word document
  13. What is represented by the small, black square in the lower-right corner of an active cell or range?
  14. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  15. MS Excel provides the default value for step in Fill Series dialog box
  16. Which of the following is the latest version of Excel
  17. You can move a sheet from one workbook into new book by
  18. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  19. Which of the cell pointer indicates that you can fill series?
  20. The autofill feature
  21. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  22. To create a formula, you can use:
  23. Concatenation of text can be done using
  24. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  25. Text formulas:
  26. B7:B9 indicates:
  27. Which setting you must modify to print a worksheet using letterhead?
  28. A circular reference is
  29. How do you rearrange the data in ascending or descending order?
  30. How do you display current date only in MS Excel?