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

When I open a workbook, excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?

624

In visual basic, I can set the color of a cell with the .interior.colorindex property. How can I read the color of a cell before I change it?

633

How do I clear all formatting and cell contents from the cell in my spreadsheet?

713

Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?

656

Why do my scrollbars go to row 500 -- my data ends in cell e50?

651

Can I write a formula that returns the number of distinct entries in a range?

649

I create lots of graphs with excel. Unfortunately, the options to which excel defaults are not the ones I use most. Is there any way to change the graph defaults to theones I prefer?

610

Show excel toolbars on two rows?

706

I am converting from quatro pro to excel. What happened to my cell comments?

675

How to open a new copy of a excel file?

701

When I try to open xl, it freezes and all I can do is reboot* excel crashes on me regularly, what can I do* excel caused an invalid page fault...* Illegal operation error when starting excel?

644

When I clear a large range, it takes forever. How can I make it faster?

595

I have lost my password in ms excel?

579

How can I copy the name of the worksheet tab to a cell in the worksheet?

606

All of a sudden, when I open the file, it asks if I want to "enable or disable a macro". There are no macros in this workbook?

647

Post New MS Excel Microsoft Questions

Un-Answered Questions { MS Excel Microsoft }

How many seats are in ms excel?

674

How do I delete the contents of an active cell?

637

What is mean by autosum?

617

Can you have tabs within tabs in excel?

604

When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. Whats wrong?

608

Well, then how do I fit something to one page wide?

653

Why should I use a pivot table?

690

Can you do multiple if then statements in excel?

660

How do you merge cells in excel for mac 2016?

620

How do I distribute rows evenly in excel 2016?

618

How can I format a worksheet to have alternating green and white rows like a "greenbar" report?

568

What is vlookup in excel with example?

735

Where is the sum function in excel?

598

How can I insert a tab in a table cell?

629

How do I enlarge the view in excel?

619

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