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?

603

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

597

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"))?

584

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

635

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?

587

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?

709

Excel uses for the indirect and address functions or formulas?

611

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

669

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

658

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

629

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

641

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

602

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

621

What is if function in excel?

654

What are pivot tables and also mention its use?

592

Post New MS Excel Microsoft Questions

Un-Answered Questions { MS Excel Microsoft }

What does the apostrophe in front of a word mean?

644

Is a spreadsheet a database?

658

What is ms excel 2010?

690

How do I write an if function in excel?

632

How can I hide or show the ribbon?

647

How do I reduce the tab size in excel?

637

How do you copy cell formatting in excel?

677

How do you unlock an excel spreadsheet for editing?

649

What is linest function in excel?

665

How do you create a formula in excel?

639

How do you merge two rows in excel?

650

How do you drag and fill in excel?

634

Is excel 365 the same as excel 2019?

572

Where is comma delimited in excel?

573

How do you insert multiple rows?

637

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