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 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.
void NotifyChanges (object Sh , Excel.Range Target) {
//No tify changes
}
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) Globals.ThisWorkbook.Application.SheetChange += new Excel.AppEvents_SheetChangeEventHandler ( NotifyChanges );
B) Globals.ThisWorkbook.Application.SheetSelectionChange += new Excel.AppEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
C) Globals.ThisWorkbook.SheetSelectionChange += new Excel.WorkbookEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
D) Globals.ThisWorkbook.SheetChange += new Excel.WorkbookEvents_SheetChangeEventHandler ( NotifyChanges );

2. You are creating an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application edits a Microsoft Office Word 2007 document. The Word document contains two XML parts. The second custom XML part is used to audit changes to the first custom XML part. You need to ensure that the application adds a new element to the second XML part each time the value of a text node in the first XML part is changed. What should you do?

A) Modify the NodeAfterInsert event for the first CustomXMLPart object.
B) Modify the StreamAfterLoad event for the CustomXMLParts collection.
C) Modify the StreamAfterAdd event for the CustomXMLParts collection.
D) Modify the NodeAfterReplace event for the first CustomXMLPart object.

3. You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Microsoft.Office.Tools.CustomTaskPane pane; private void CreatePane () { pane = this.CustomTaskPanes.Add (new MyUserControl (), "Do Something"); pane.Visible = true; }
Users must open multiple workbooks in Excel.
You need to ensure that the add-in displays the same instance of the task pane when a
user views any of the open workbooks.
What should you do?

A) Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }
B) Create the following event handler for the Application.WorkbookActivate event. void Application_WorkbookActivate ( Excel.Workbook Wb ) { CreatePane (); }
C) Create the following event handler for the Application.WorkbookOpen event. void Application_WorkbookOpen ( Excel.Workbook Wb ) { CreatePane (); }
D) Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Excel.Workbook Wb, Excel.Window Wn ) { CreatePane (); }

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.Application.SheetChange, _ AddressOf Me.NotifyChanges
B) AddHandler Globals.ThisWorkbook.SheetChange, _ AddressOf Me.NotifyChanges
C) AddHandler Globals.ThisWorkbook.SheetSelectionChange, _ AddressOf Me.NotifyChanges
D) AddHandler Globals.ThisWorkbook.Application. _ SheetSelectionChange, Add ressOf Me.NotifyChanges

5. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customization contains a predefined schema to validate the data that users add. The path to the schema is stored in a variable named filename. The Unique Resource Identifier (URI) for the schema is stored in a variable named uri. The alias for the schema is stored in a variable named alias.
You need to ensure that the schema that the user selects is applied to the solution document. Which code segment should you use?

A) Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)
B) Me.Application.XMLNamespaces.Add (filename, uri , [alias], True)
C) Me.XMLNodes.Add (filename, "", uri )
D) Dim doc As ThisDocument = Globals.ThisDocument Me.Application.XMLNamespaces.Item(uri). _ AttachToDocument(doc)

Solutions: