Prep and try our 070-543 valid and latest training questions & answers

Microsoft 070-543 Exam Overview:

Microsoft 070-543 Exam Syllabus Topics:

Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. You are creating an add-in for Microsoft Office Outlook by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code. (Line numbers are included for reference only.)
01 List< Outlook.MAPIFolder > folders;
02 Outlook.Explorer explorer;
03
04 public void CreateCollection () {
05 explorer = Application.ActiveExplorer ();
06 folders = new List< Outlook.MAPIFolder >();
07 ProcessFolders ( explorer.CurrentFolder );
08 }
09
10 public void ProcessFolders ( Outlook.MAPIFolder folder) {
11 ... 12 }
You need to ensure that the folders collection includes all the folders and subfolders within the selected Outlook folder.
Which code segment should you insert at line 11?

A) foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
folders.Add ( fldr ); }
B) folders.AddRange ((List< Outlook.MAPIFolder >) folder.Folders );
C) foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
folders.Add ( fldr );
ProcessFolders ( fldr ); }
D) foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
ProcessFolders ( fldr ); }

2. You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains code that customizes the Ribbon user interface (UI). You run the add-in. The add-in does not customize the Ribbon UI and does not display an exception. You need to display the exceptions in the user interface of the add-in when the add-in starts. What should you do?

A) Add a new application configuration file to your project by using the following XML fragment. < configuration > < appSettings > < add key="Debug" value="True"/ > < /appSettings > < /configuration >
B) In the Configuration Manager dialog box for the add-in project, set Active Configuration to Debug.
C) Under the Word 2007 options, select the Show add-in user interface errors check box.
D) Add a new application configuration file to your project by using the following XML
fragment.
< configuration > < appSettings > < add key="ShowErrors" value="True"/ > < /appSettings > < /configuration >

3. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You create the following objects in the solution:
a DataSet object named AWDataSet that contains two tables named Product and SalesOrderDetail
a BindingSource object named ProductsBindingSource
a bookmark that is bound to the SalesOrderDetail table You need to retrieve the active row from the solution .
Which code segment should you use?

A) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.SyncRoot )).Row);
B) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.DataSource )).Row);
C) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.Current )).Row);
D) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( (object)this.productBindingSource.Filter)).Row);

4. You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add the following method to the workbook class.
Private Sub NotifyChanges _
(ByVal Sh As Object, ByVal Target As Excel.Range)
'Notify changes
End Sub
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?

A) AddHandler Globals.ThisWorkbook.SheetChange, _ AddressOf Me.NotifyChanges
B) AddHandler Globals.ThisWorkbook.Application. _ SheetSelectionChange, Add ressOf Me.NotifyChanges
C) AddHandler Globals.ThisWorkbook.Application.SheetChange, _ AddressOf Me.NotifyChanges
D) AddHandler Globals.ThisWorkbook.SheetSelectionChange, _ AddressOf Me.NotifyChanges

5. You create an add-in for Microsoft Office PowerPoint by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the add-in by using Microsoft Visual Studio. Users report that the add-in is unavailable in PowerPoint. Users do not receive any error message. You need to ensure that the add-in is available in PowerPoint. What should you do?

A) Modify the registry to include the appropriate entries.
B) Copy the add-in assembly to the Microsoft Office folder.
C) Edit the application manifest to point to the add-in assembly.
D) Add the add-in assembly to the global assembly cache.

Solutions: