MS Office 2010 Interview Questions

MS Office 2010 Interview Questions

Question
What the major difference between MS Office 2010 & 2007 ?
Answer
 
Enhanced Image Editing o Microsoft Office 2010 introduced new features to the built-in image editor included with Word, Excel, and PowerPoint. The new features allow you to enhance images within your documents with a variety of artistic photo effects, much like the photo filters of Adobe Photoshop. The image tools of Office 2010 also allow you to remove the background of pictures and clip art, providing you with a powerful tool for seamlessly integrating images in your documents. Application-Specific Features o Each of the Microsoft Office 2010 application comes with a variety of new features not included in Office 2007. Outlook 2010 includes conversation management tools, an enhanced calendar preview, and enhanced support for Windows Mobile devices. Excel 2010 features a new “Sparklines” feature that creates enhanced visual representations of data. PowerPoint 2010 comes with a much-needed upgrade to its video and image editing tools, and includes enhanced support for video integration in your presentations. Finally, Word 2010 includes dozens of new WordArt effects and the ability to capture screenshots from within the application.
 
Question
How to use mail merge ?
Answer
Start a mail merge. To do this, follow these steps, as appropriate for the version of Word that you are running. Microsoft Word 2002 On the Tools menu, click Letters and Mailings, and then click Mail Merge Wizard. Microsoft Office Word 2003 On the Tools menu, click Letters and Mailings, and then click Mail Merge. Microsoft Office Word 2007 On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard. Select document type In the Mail Merge task pane, click Letters. This will allow you to send letters to a group of people and personalize the results of the letter that each person receives. Click Next: Starting document.
 
Question
Which all Operating systems support MS Office 2010 ?
Answer
 
All Microsoft windows higher version then xp supports ms 2010.
 
Question
What is Advance MS Office 2010?
Answer
1.Word 2010 Insert a screenshot,Crop images to a shape,New photo-editing options,Navigation pane. 2.Excel 2010 Sparklines,Slicers,64-bit support. 3.Outlook 2010 Conversation view: MailTips,Social connector,Quick steps,Cleanup. 4.PowerPoint 2010 Video editing,Broadcast slideshows,Distribute slideshows as video, Animation painter: Sections,Transition improvements. 4.PowerPoint 2010 Video editing,Broadcast slideshows,Distribute slideshows as video, Animation painter: Sections,Transition improvements.
 
Question
 
What is the benefit of advance feature?
Answer
1.Word 2010 Insert a screenshot,Crop images to a shape,New photo-editing options,Navigation pane. 2.Excel 2010 Sparklines,Slicers,64-bit support. 3.Outlook 2010 Conversation view: MailTips,Social connector,Quick steps,Cleanup. 4.PowerPoint 2010 Video editing,Broadcast slideshows,Distribute slideshows as video, Animation painter: Sections,Transition improvements. 5.OUT look 2010 many (10)email id config in outlook improvements.
 
Question
List us the features of Advanced MS Office 2010?
Answer
 
1.Word 2010 Insert a screenshot,Crop images to a shape,New photo-editing options,Navigation pane. 2.Excel 2010 Sparklines,Slicers,64-bit support. 3.Outlook 2010 Conversation view: MailTips,Social connector,Quick steps,Cleanup. 4.PowerPoint 2010 Video editing,Broadcast slideshows,Distribute slideshows as video, Animation painter: Sections,Transition improvements. 5.OUT look 2010 many (10)email id config in outlook improvements.
 
Question
How to write macro for pivot table automation ?
Answer
Start with Sub CreatePT() Dim PT As PivotTable Set PT = ActiveSheet.PivotTableWizard(SourceType:=xlDatabase, SourceData:=Range(“A1:D200”)) With PT .PivotFields(“Year”).Orientation = xlRowField .PivotFields(“Sales”).Orientation = xlColumnField End With End Sub
 
Question
What is Tracking options in WORD 2010
Answer
 
You can customize the status bar to add an indicator that tells you when change tracking is on or off. When the Track Changes feature is on, you can view all of the changes that you make in a document. When you turn off the Track Changes feature, you can make changes to a document without marking what has changed.
 
Question
What is Tracking options in WORD 2010
Answer
You can customize the status bar to add an indicator that tells you when change tracking is on or off. When the Track Changes feature is on, you can view all of the changes that you make in a document. When you turn off the Track Changes feature, you can make changes to a document without marking what has changed.
 
Question
How to write macro for pivot table automation report ?
Answer
Start with Sub CreatePT() Dim PT As PivotTable Set PT = ActiveSheet.PivotTableWizard(SourceType:=xlDatabase, SourceData:=Range(“A1:D200”)) With PT .PivotFields(“Year”).Orientation = xlRowField .PivotFields(“Sales”).Orientation = xlColumnField End With End Sub
 
Question
Is it possible to convert my excel doc to any html page for report purpose?
 
Answer
Using the Save As command can save a selection data in Microsoft Excel as a web page (html file). Step 1: Select the range you want to export as html file. Step 2: Click the File tab in Excel 2010 or click the button in Excel 2007; Step 3: Click Save As button; Step 4: In the Save As dialog box, choose a location that you will put the file, and select the Web Page from Save as type section, and then check the Selection in Save section. See screenshot: Step 5: Click the Save button. Step 6: Now you will get into the Publish as Web Page dialog box, click the Publish button. See screenshot: Plz refer below link, http://www.extendoffice.com/documents/excel/674-excel-export-to-html.html
 
Question
How can be create charts connecting to sharepoint in Office 2010
Answer
The Chart Web Part is a Web Part that can be created and added to a SharePoint site to enable users to view performance and other types of information at a glance. For example, you can use a Chart Web Part to see sales amounts across different teams or geographical regions in a retail organization. Bar chart Area chart Line chart Point/Bubble chart Financial chart Pie chart Radar chart Gantt/Range Column chart Range chart Error Bar chart BoxPlot chart Funnel chart Pyramid chart
 
Question
What are the new functions introduced in Excel of Advance MS Office 2010
Answer
 
There are a ton of new and cool features in Excel 2010. My favorite new features are, Sparklines Slicers Improved Tables & Filters New Screenshot Feature: Paste Previews: Improved Conditional Formatting: Customize Pivot Tables Quickly Customize Add-ins from Developer Ribbon Customize Ribbons and Define your own Ribbons One File Menu to Rule them all