Pass with 070-543 Practice Materials 100% for sure

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. doc.CachedData.FromXml(filepath);
• B. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• C. doc.CachedData.HostItems.Add(filepath);
• D. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());

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.Application.XMLNamespaces.Add (filename, uri , [alias], True)
• B. Dim doc As ThisDocument = Globals.ThisDocument Me.Application.XMLNamespaces.Item(uri). _ AttachToDocument(doc)
• C. Me.XMLNodes.Add (filename, "", uri )
• D. Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in fills in sales forecast data for each month in an Excel sheet. You write the following method. (Line numbers are included for reference only.)
01 public void FillMonths () {
02 Excel.Application app = Globals.ThisAddIn.Application ;
03 Excel.Worksheet ws = app.ActiveSheet as Excel.Worksheet ;
04 ...
05 }
You need to insert the names of the months into the cells in the range A1 through A12.
Which code segment should you insert at line 04?

• A. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( ws.get_Range ("A2:A12", Type.Missing ), Excel.XlAutoFillType.xlFillMonths );
• B. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( ws.get_Range ("A1:A12", Type.Missing ), Excel.XlAutoFillType.xlFillMonths )
• C. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( rng.EntireColumn , Excel.XlAutoFillType.xlFillMonths );
• D. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( rng , Excel.XlAutoFillType.xlFillMonths );

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in customizes the Ribbon user interface (UI). The add-in contains a file named Ribbon1.xml that has the following markup for two buttons.
<button id="Btn1" onAction =" DoOperation " />
<button id="Btn2" onAction =" DoOperation " />
You need to create a callback function that runs different code for the buttons.
Which code segment should you use?

• A. public void DoOperation (Control control ) { if ( control.ProductName.Equals ("Btn1")) { //Btn1 click } else { //Btn2 click } }
• B. public void DoOperation ( Office.IRibbonControl control) { if ( control.Id == "Btn1") { //Btn1 click } else { //Btn2 click } }
• C. public void DoOperation ( Office.IRibbonControl control) { if ( control.Tag == "Btn1") { //Btn1 click } else { //Btn2 click } }
• D. public void DoOperation (Control control ) { if ( control.Text == "Btn1") { //Btn1 click } else { //Btn2 click } }

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution document refers to the following bugs:
bug123
Bug514
BUG512
The solution document must provide more details about a bug whenever a reference to the bug is found in the document.
You need to create a smart tag that identifies each bug.
Which code segment should you use?

• A. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"[B|b][U|u][G|g]000"); tag.Expressions.Add(regex);
• B. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"bug\d\d\d");
• C. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"bug\d\d\d", RegexOptions.IgnoreCase); tag.Expressions.Add(regex);
• D. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"[B|b][U|u][G|g]000");