Free Microsoft 070-543 Exam Dumps Questions & Answers

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The Excel workbook contains a worksheet object named Sheet1 that contains data in the range A1 through A5.
You write the following lines of code for the Sheet1 object. (Line numbers are included for reference only.)
01 Word.Application app = new Word.Application ();
02 Word.Document doc;
03 ...
04 object index = 1;
05 Word.Bookmark bMark = doc.Bookmarks.get_Item (
ref index);
06 ...
You need to insert the data from the range A1 through A5 into a Microsoft Office Word document after bMark. Your solution must retain the sequence of the data that is inserted.
Which code segment should you insert at line 06?

• A.Excel.Range rng = this. get_ Range ( "A2", "A5" ) ; bMark.Range.Text = this. get_ Range ( "A1", System.Type.Missing ) .Value2.ToString(); foreach ( Excel.Range r in rng.Rows ) { bMark.Range.InsertAfter (r.Value2.ToString()); }
• B.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; string temp = ""; foreach ( Excel.Range r in rng.Cells ) { temp = temp + r.Value2.ToString(); } bMark.Range.InsertAfter (temp);
• C.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; string temp = ""; foreach ( Excel.Range r in rng.Rows ) { temp = temp + r.Text.ToString (); } bMark.Range.Text = temp;
• D.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; foreach ( Excel.Range r in rng.Cells ) { bMark.Range.InsertAfter (r.Value2.ToString()); }

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.Copy the add-in assembly to the Microsoft Office folder.
• B.Edit the application manifest to point to the add-in assembly.
• C.Add the add-in assembly to the global assembly cache.
• D.Modify the registry to include the appropriate entries.

You develop a document-level solution for Microsoft Office Excel 2003 by using Visual
Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the worksheet class.
void Handle_Change ( Excel.Range Target) {
//.. .
}
You need to ensure that the Handle_Change method runs only when the data in the range A1 through E5 changes.
Which code segment should you add to the Startup event of the worksheet class?

• A.Excel.Range rng = this.Range ["A1", "E5 "];
  this.Change += new Excel.DocEvents_ChangeEventHandler ( Handle_Change );
• B.Excel.Range rng = this.Range ["A1", "E5"]; Microsoft.Office.Tools.Excel.NamedRange rng1 = this.Controls.AddNamedRange ( rng , " MyRange ");
  rng1.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( Handle_Change );
• C.Excel.Range rng = this.Range ["A1", "E5"]; Microsoft.Office.Tools.Excel.NamedRange rng1 = this.Controls.AddNamedRange ( rng , " MyRange ");
  rng1.Change += new Excel.DocEvents_ChangeEventHandler ( Handle_Change );
• D.Excel.Range rng = this.Range ["A1", "E5"];
  this.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( Handle_Change );

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You customize the Ribbon user interface (UI). You add a Ribbon1.xml file to the add-in. You need to add a built-in save function to a custom tab in the Ribbon UI. Which XML fragment should you use?

• A.< customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" xmlns:x =" MyNamespace " > ... < button idQ =" x:FileSave " / > ... < / customUI >
• B.< customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button idMso =" FileSave " / > ... < / customUI >
• C.< customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button id=" FileSave " / > ... < / customUI >
• D.< customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button tag=" FileSave " / > ... < / customUI >

You create a document-level solution for Microsoft Office Excel 2003 by using Visual
Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?

• A.this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesBindingSource.Insert ( 0, adventureWorksDWDataSet.FactResellerSales );
• B.this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesTableAdapter.Update ( adventureWorksDWDataSet.FactResellerSales );
• C.XLNRange.Merge ( this.Range ["A1", "B3"]);
• D.XLNRange.AutoFill ( this.Range ["A1", "B3"], Excel.XlAutoFillType.xlFillDefault );