Prepare Interview

Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address
Check our LIVE MOCK INTERVIEWS

Microsoft Excel Interview Questions and Answers

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

Intermediate / 1 to 5 years experienced level questions & answers

Ques 1. 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
 

Ques 2. Is it possible to prevent someone from copying the cell from your worksheet?

Yes, it is possible. In order to protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect sheet > Password.  By entering password, you can secure your worksheet from getting copied by others.

Is it helpful? Add Comment View Comments
 

Ques 3. What does a LOOK UP function searches in the MS Excel?

In Microsoft excel, the LOOKUP function returns a value from a range or from an array.

Is it helpful? Add Comment View Comments
 

Ques 4. What is the AND function does in excel?

Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.

Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5,   and ‘False’ if any of those values<5. You can use AND function to do that.

Is it helpful? Add Comment View Comments
 

Ques 5. What is the quick way to return to a specific area of a worksheet?

The quick way to return to a specific area of worksheet is by using name box.  You can type the cell address or range name in name box to return to a specific area of a worksheet.

Is it helpful? Add Comment View Comments
 

Ques 6. 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
 

Most helpful rated by users:

Related interview subjects

Operating System interview questions and answers - Total 22 questions
Computer Networking interview questions and answers - Total 65 questions
Microsoft Excel interview questions and answers - Total 37 questions
Computer Basics interview questions and answers - Total 62 questions
Tips and Tricks interview questions and answers - Total 30 questions
©2023 WithoutBook