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?

570

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

568

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

570

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

577

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?

547

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?

653

Excel uses for the indirect and address functions or formulas?

584

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

648

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

639

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

601

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

600

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

567

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

592

What is if function in excel?

594

What are pivot tables and also mention its use?

534

Post New MS Excel Microsoft Questions

Un-Answered Questions { MS Excel Microsoft }

I have lost my password in ms excel?

537

How do you insert a row?

689

What do you call it when you combine two names?

593

What is an array formula?

639

How do I customize the ribbon in excel 365?

612

What is difference between lookup and vlookup?

589

How do I automatically count rows in excel?

693

What laptops come with word and excel?

632

How do I fix character length in excel?

642

How do I change the default font in excel 2019?

626

How many rows and columns 2018 excel?

626

What do you mean by filtering?

622

Is there a free version of excel?

627

Which key is used for help in ms excel?

568

How do you make an excel sheet online?

523

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