Prepare Interview

Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Microsoft Excel Interview Questions and Answers

Test your skills through the online practice test: Microsoft Excel Quiz Online Practice Test

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.

Is it helpful? Add Comment View Comments
 

Ques 2. What is Microsoft Excel?

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

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

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.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2023 WithoutBook