Here you can find Microsoft Office Interview Questions and Answers.
In this Microsoft Office Interview Questions and Answers section you can learn and practice Microsoft Office Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Microsoft Office interview.
AllIndiaExams provides you lots Microsoft Office Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Microsoft Office Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Microsoft Office Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Microsoft Office technical interview.
Can I Search and Replace for things other than words in MS Word?
Yes! 1. Choose Replace from the Edit menu. 2. Click on More. At the bottom of the Find and Replace dialog box, you'll see a Format button and a Special button. The Format button allows you to replace formatting (e.g., one font for another, bold for italics); the Special button allows you to replace special characters (e.g., paragraph marks, note reference marks). Also, you can use the contents of the Clipboard as the replacement. This is useful if you want to replace a short word or phrase with a longer phrase or paragraph. To use this feature, you must first create the replacement text somewhere, then copy it to the Clipboard. When you use the Special button as mentioned above, you'll see Clipboard Contents as one of the choices (or use ^c).
Can I see how my MS Word document will look if I accept or delete the changes?
Yes, there are several options on the reviewing toolbar for previewing your doument.
How do I customize the Toolbar in MS Word?
If you want all of the choices in the menu bar to display when you mouse click on the menu (that way you don't have the expand arrow at the bottom), do the following: * On the Tools menu, click Customize * Click the Options tab * Checkmark the Always show full menus
Can I use the SHOW menu to remove revisions from a MS Word document?
NO! When you remove the checkmarks by the items in the SHOW menu, it just hides the revisions. The revisions will show up the next time that the document is opened either by yourself or by the reviewers. There is only one way to remove revisions and comments and that is by accepting or deleting them.
How do I turn-Off the Drawing Canvas in MS Word?
When you insert a drawing object in Word, a drawing canvas is placed around it. The drawing canvas helps you arrange a drawing in your document, and it's especially helpful if your drawing consists of several shapes. While you can easily delete the drawing canvas on a case-by-case basis (drag the drawing object off the drawing canvas, select the drawing canvas, and then delete it), you may wish to prevent it from being created to begin with. To stop the automatic creation of the drawing canvas On the Tools menu, click Options. Click the General tab Under General options, deselect the last option; automatically create drawing canvas when inserting AutoShapes.
How to Change the Sheet Tab Color of Excel Spreadsheets?
In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the color of worksheets tabs containing related information can make it easier to navigate through very . Or to use tab colors to differentiate between sheets containing unrelated information.
Show Excel Toolbars on Two Rows?
The default setting for Excel toolbars is to display them on a single row, thereby hiding many of the toolbar buttons. It is quite easy to change the default settings to show Excel toolbars on two rows, making for a easier time formatting your spreadsheet.
Upload data from Excel into SAP?
Some of the Business functions (BAPI's / RFC unctions) offer data upload The general tool in SAP for data upload is the Batch input / call transactions In the batch input file you specify screen by screen and field by field the input to SAP. SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.
What are Excel Spreadsheet Number Formats?
Number formatting in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.
How Do You Use the SUM and AutoSUM Functions in Excel?
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
What does PowerPoint environment contain?
PowerPoint environment is usually made up of Quick Access Toolbar, Ribbon, Slides tab, Outline tab, Slide Views, Zoom Control and Scroll bar.
What is the purpose of Quick Access Toolbar?
This toolbar lets one access common commands such as save, undo and repeat no matter which tab you are on in the ribbon.
What is the purpose of Ribbon?
The ribbon is designed to help you quickly find the commands that you need to complete a task.
What is the purpose of Slides tab?
Slides tab is used to view and work with the slides.
What is the purpose of Outline tab?
The Outline tab displays the text content of the slides.
State the criteria which a trusted publisher should meet before adding him?
The following criteria should be met by the publisher before adding him to the list. The code project should have a digital signature of the publisher A valid digital signature should be in place Valid digital signature should not be expired Digital certificate which comes with digital signature should meet industry standards and specifications. Developer who is holding and signing the code project should be a trusted publisher
Name at least six file extensions of Microsoft Access?
Some of the file extensions present in MS Access are Access blank project template .adn Access database .accdb Access project .adp Access Workgroup .mdw Protected access database .accde Access workgroup .mdw
Explain about the protection features present in MS Access?
If a programmer doesn’t wish to make changes to the document he can lock the document data and its code from further changes by changing the extension of the file system to .MDE. Changes can be made only to the file with an extension MDE. Tools are available in the market which can unlock and decompile the code but some changes to VBA or VB scripts are irreversible.
State some of the uses of MS Access?
MS Access provides a huge range of functions some of them are It is used by small business, departments of large corporations, and by amateurs to create applications on their desktop for data applications. Access is very useful for small web based database applications hosted on IIS and using ASP.NET pages. It can be used as a RAD for building prototype and Stand alone applications. Access can be used as a frontend while the backend can be a ODBC compliant product.
Explain about the various features present in MS Access?
Microsoft access has huge benefits for a programmer and end user. Some of the benefits are Relative compatibility with SQL and VBA. Microsoft SQL server desktop engine is embedded into the Access suite along with Jetdata base engine which can further help you in programming. MS Access allows forms to contain data which is altered as changes are made to the underlying table. It has features which support the creation of all objects in the underlying server.
What is HTTP Protocol?
The HTTP (Hyper Text Transfer Protocol) is not a protocol dedicated for email communications, but it can be used for accessing your mailbox. Also called web based email, this protocol can be used to compose or retrieve emails from an your account. Hotmail is a good example of using HTTP as an email protocol.
What is SMTP Protocol?
The SMTP (Simple Mail Transfer Protocol) protocol is used by the Mail Transfer Agent (MTA) to deliver your Email to the recipient's mail server. The SMTP protocol can only be used to send emails, not to receive them. Depending on your network / ISP settings, you may only be able to use the SMTP protocol under certain conditions (see incoming and outgoing mail servers) see also SMTP RFC
What is POP3 Protocol?
The POP (Post Office Protocol 3) protocol provides a simple, standardized way for users to access mailboxes and download messages to their computers. When using the POP protocol all your email messages will be downloaded from the mail server to your local computer. You can choose to leave copies of your emails on the server as well. The advantage is that once your messages are downloaded you can cut the internet connection and read your email at your leisure without incurring further communication costs. On the other hand you might have transferred a lot of message (including spam or viruses) in which you are not at all interested at this point. See also POP3 Description (RFC)
What is IMAP Protocol?
IMAP (Internet Message Access Protocol) –Is a standard protocol for accessing e-mail from your local server. IMAP is a client/server protocol in which e-mail is received and held for you by your Internet server. As this requires only a small data transfer this works well even over a slow connection such as a modem. Only if you request to read a specific email message will it be downloaded from the server. You can also create and manipulate folders or mailboxes on the server; delete messages etc. see also IMAP.org
Explain Email Protocol?
Basically, a protocol is about a standard method used at each end of a communication channel, in order to properly transmit information. In order to deal with your email you must use a mail client to access a mail server. The mail client and mail server can exchange information with each other using a variety of protocols.
MS Word Interview Questions & Answers
MS Excel Interview Questions & Answers
MS PowerPoint Interview Questions
MS Access Interview Questions & Answers
MS Outlook Interview Questions & Answers