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?

612

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

602

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

588

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

643

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?

594

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?

718

Excel uses for the indirect and address functions or formulas?

616

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

681

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

665

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

637

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

651

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

610

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

626

What is if function in excel?

669

What are pivot tables and also mention its use?

605

Post New MS Excel Microsoft Questions

Un-Answered Questions { MS Excel Microsoft }

How can I enter the symbol for the new euro currency in my spreadsheet?

631

Is excel 365 the same as excel 2016?

593

How many types of work in ms excel?

712

How do you delete hidden tabs in excel?

668

What is scenario planning used for?

704

What is countif function in excel?

777

Where can I find solver in excel?

653

What common problems do a collection of spreadsheets created by end users share with the typical file system?

807

How do I randomize a list of names in excel?

695

What is cell style in excel?

597

How do you enter data into a spreadsheet?

698

Why is pivot table used?

593

How do I fix a name error in excel?

653

How do I create a scenario summary report in excel?

803

How do I compare text in excel?

679

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