MS Excel Microsoft Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MS Excel Microsoft Interview Questions

Questions Answers Views Company eMail

Is there a way to determine the last active column in a spreadsheet?

643

My stop recording toolbar has disappeared. How do I get it back?

633

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?

619

I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?

700

I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

627

I have created some clever formulas, and I don not want anyone else to see them. Is it possible to hide the formulas but display the results?

777

Excel uses for the indirect and address functions or formulas?

651

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

720

In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?

691

Differentiate between count, counta, countif, and countblank in ms-excel.

666

What is the difference between substitute and replace function in ms-excel?

685

How can the users return to any particular area of a worksheet?

654

What is the role of cell reference in the calculation in excel?

673

What is if function in excel?

724

What are pivot tables and also mention its use?

651

Post New MS Excel Microsoft Questions

Un-Answered Questions { MS Excel Microsoft }

How do you merge columns in excel and keep all data?

868

How many rows can excel have?

654

What is a excel sheet?

674

Can you compare two excel spreadsheets for differences?

670

I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with visual basic?

615

Can I just buy excel?

726

How do I change the color of a cell in excel based on formulas?

800

How to use vlookup in excel 2016?

761

What is the function of vlookup in excel?

676

Can you freeze a table in excel?

726

What is string in ms excel?

816

What is a substring in excel?

806

How to delete a scenario in excel?

750

What is the shortcut key to auto fill or fill down in excel?

681

What is the difference between ms word and ms excel?

731

For More Un-Answered { MS Excel Microsoft } Questions Click Here