Get real 70-543 exam questions for better preparation

Microsoft 70-543 Exam Overview:

Microsoft 70-543 Exam Syllabus Topics:

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

1. You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?

A) Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.
B) Delete the itemProps1.xml file.
C) Delete the item1.xml file.
D) Create a file named itemProps2.xml that marks the item2.xml file as a data store.

2. You are creating an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application contains the following objects:
a DataSet object named OrderData
a ServerDocument object named sd1
You write the following lines of code. (Line numbers are included for reference only.)
01 System.Text.StringBuilder stringIn =
02 new System.Text.StringBuilder ();
03 System.IO.StringWriter stringOut =
04 new System.IO.StringWriter ( stringIn );
05 ...
06 sd1.Save();
You need to store the contents of the OrderData object in the document cache for offline use.
Which code segment should you insert at line 05?

A) OrderData.WriteXml ( stringOut , XmlWriteMode.WriteSchema ); orderdataitem.Xml = stringIn.ToString ();
B) OrderData.WriteXml ( stringOut , XmlWriteMode.WriteSchema ); orderdataitem.Schema = stringIn.ToString ();
C) OrderData.WriteXml ( stringOut , XmlWriteMode.IgnoreSchema ); orderdataitem.Xml = stringIn.ToString ();
D) OrderData.WriteXml ( stringOut , XmlWriteMode.IgnoreSchema ); orderdataitem.Schema = stringIn.ToString ();

3. You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add two Text content controls named control1 and control2 to the template.
The template contains the following custom XML fragment.
< ProductList >
<Product id="1">
<Name> Chai </Name>
</Product>
<Product id="2">
<Name>Chang</Name>
</Product> </ ProductList >
You need to ensure that control1 displays the id of the Product and control2 displays the name of the Product.
Which code segment should you use?

A) control1.XMLMapping.SetMapping("/ ProductList /Product[1]/@id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product[1]/name", "", ActiveWindow.Document.CustomXMLParts [1]);
B) control1.XMLMapping.SetMapping("/ ProductList /Product/@id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product/name", "", ActiveWindow.Document.CustomXMLParts [1]);
C) control1.XMLMapping.SetMapping("/ ProductList /Product/id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping( " / ProductList /Product/name", "", ActiveWindow.Document.CustomXMLParts [1]);
D) control1.XMLMapping.SetMapping("/ ProductList /Product[1]/id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product[1]/name", "", ActiveWindow.Document.CustomXMLParts [1]);

4. You create an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). You create the following method in the add-in.
void DisplayTotal ( Excel.Range rng ) { //Display total }
You write the following code segment in the startup event of the add-in.
Excel.Worksheet ws = Globals.ThisAddIn.Application .
ActiveSheet as Excel.Worksheet ;
ws.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( ws_SelectionChange );
The add-in must display the sum of the values in a selected range. If multiple ranges are selected, the add-in must display only the sum of the values in the first selected range.
You need to meet the outlined requirements.
Which code segment should you use?

A) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.CurrentRegion ); }
B) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [1]); }
C) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Previous ); }
D) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [0]); }

5. You create an add-in for a Microsoft Office Outlook application by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a reference to an Outlook folder in a variable named folder. You need to process only the e-mail messages within the folder. Which code segment should you use?

A) foreach (object item in folder.Items ) { if ((item as Outlook.MailItem ).Class == Outlook.OlObjectClass.olMail ) { //Process mail } }
B) foreach (object item in folder.Items ) { if (item is Outlook.MailItem ) { //Process mail } }
C) foreach ( Outlook.MailItem item in folder.Items ) { if ( item.Class == Outlook.OlObjectClass.olMail ) { //Process mail } }
D) foreach ( Outlook.MailItem item in folder.Items ) { //Process mail }

Solutions: