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?

642

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

632

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?

776

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.

665

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 }

What is the difference between merging and splitting cells?

729

What is a foreign key in excel?

728

How to compare combination of columns in excel?

757

Why is data validation important?

649

What do you mean by filtering?

679

How do you copy just the formatting in excel?

863

How do I apply a conditional formula in excel?

703

What is the name manager in excel?

776

Does excel and word come with windows 10?

689

How is the new excel worksheet added?

627

What is vba in excel?

857

How do I extend the trendline in excel 2019?

797

Can't find excel on windows 10?

730

What are the 3 types of cell references in excel?

694

Can you use excel as a database?

673

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