MS Office Microsoft Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MS Office Microsoft Interview Questions

Questions Answers Views Company eMail

Is there a way that I can close all spreadsheets in my excel file at once?

608

How to change the sheet tab color of excel spreadsheets?

708

Why does excel say my file has links, when I know it does not?

717

While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered12,00. Obviously the comma was placed in the incorrect position, but excel interpreted this as text. When I wrote my sum formula, the results were not as expected.how can this be avoided in the future?

635

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?

616

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?

612

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

705

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?

640

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

640

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

636

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?

600

Show excel toolbars on two rows?

694

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

667

How to open a new copy of a excel file?

690

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?

631

Un-Answered Questions { MS Office Microsoft }

How do I freeze my screen when presenting?

344

Where is outlook exe located?

How do I turn off auto text?

547

Is there an if contains function in excel?

630

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?

612

How do I lock a formula in excel?

637

How do you remove lines from a table?

646

How do I edit a template in word 2010?

584

How do you copy formatting in sheets?

660

What is the meaning of #ref in excel?

635

What is the difference between a presentation and a slide?

354

How do you autosum multiple rows in excel?

634

How do I lock in my title row and keep it visible while I scroll down to see the rest of my data?

677

How do I write fractions in word 2007?

581

What are the elements of ms word?

586

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