Question
a.
counts cells having alphabets
b.
counts empty cells
c.
counts cells having number
d.
counts non-empty cells
Posted under MS Office
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What does COUNTA () function do?
Similar Questions
Discover Related MCQs
Q. What is the short cut key to highlight the entire column?
View solution
Q. In the formula, which symbol specifies the fixed columns or rows?
View solution
Q. Excel displays the current cell address in the ........
View solution
Q. What is the correct way to refer the cell A10 on sheet3 from sheet1?
View solution
Q. Which language is used to create macros in Excel?
View solution
Q. Which of the following is not a term of MS-Excel?
View solution
Q. How many worksheets can a workbook have?
View solution
Q. Which would you choose to create a bar diagram?
View solution
Q. Which setting you must modify to print a worksheet using letterhead?
View solution
Q. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
View solution
Q. The spelling dialog box can be involved by choosing spelling from ________ menu.
View solution
Q. Which key do you press to check spelling?
View solution
Q. To record a sequence of keystrokes and mouse actions to play back later we use:
View solution
Q. We can save and protect the workbook by
View solution
Q. The first cell in EXCEL worksheet is labeled as
View solution
Q. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
View solution
Q. What are the tabs that appear at the bottom of each workbook called?
View solution
Q. What is represented by the small, black square in the lower-right corner of an active cell or range?
View solution
Q. In Excel, a Data Series is defined as what?
View solution
Q. In Excel, the Fill Color button on the Formatting toolbar is used for what?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
Microprocessor
Understand the heart of your computer with our Microprocessor MCQs. Topics include...
Java Programming
Level up your coding skills with our Java Programming MCQs. From object-oriented...