Microsoft Excel Interview Questions and Answers

Ques 1. What is the difference among COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel?

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.

Ques 2. What is Microsoft Excel?

Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.

Ques 3. What is ribbon?

The ribbon runs on the top of the application and is the replacement for the toolbars and menus.  The ribbons have various tabs on the top, and each tab has its own group of commands.

Ques 4. How can I hide or show the ribbon?

By pressing the CTRL key and pressing the F1 key to toggle you can see and hide the ribbon.

Ques 5. How can you wrap the text within a cell?

You have to select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.