Microsoft Excel Interview Questions and Answers
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.
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.
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.
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.
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.
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.
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?
Related interview subjects
Microsoft Excel interview questions and answers - Total 37 questions |
Computer Networking interview questions and answers - Total 65 questions |
Computer Basics interview questions and answers - Total 62 questions |
Computer Science interview questions and answers - Total 50 questions |
MS Word interview questions and answers - Total 50 questions |
Operating System interview questions and answers - Total 22 questions |
Tips and Tricks interview questions and answers - Total 30 questions |
PoowerPoint interview questions and answers - Total 50 questions |
Data Structures interview questions and answers - Total 49 questions |