070-543 무료 덤프문제 온라인 액세스

You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application modifies a Microsoft Office Excel custom workbook. The custom workbook displays the data that is contained in an XML file named Salesorder.xml. The Salesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both the Salesorder.xml file and the Salesorder.xsd file are located in the C:\Data folder. You need to ensure that the data in the Salesorder.xml file is available for mapping. Which code segment should you use?

• A.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• B.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• C.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• D.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);

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.
Private Sub DisplayTotal(ByVal rng As Excel.Range) 'Display total End Sub
You write the following code segment in the startup event of the add-in.
Dim ws As Excel.Worksheet = CType _ (Globals.ThisAddIn.Application.ActiveSheet, Excel.Worksheet)
AddHandler ws.SelectionChange, AddressOf Me.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.Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.CurrentRegion) End Sub
• B.Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Previous) End Sub
• C.Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(0)) End Sub
• D.Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(1)) End Sub

You are creating an add-in for Microsoft Office Word 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 Try
02 Dim par As Word.Paragraph = _
Me.Application.ActiveDocument.Paragraphs (2)
03 par.Range.Text = ""
04 ...
The application throws an exception if the active Word document does not contain a second paragraph.
You need to handle the exception.
Which code segment should you insert at line 04?

• A.Catch ex As InvalidRangeException ... End Try
• B.Catch ex As IOException ... End Try
• C.Catch ex As IndexOutOfRangeException ... End Try
• D.Catch ex As COMException ... End Try

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 must meet the following requirements: The solution must save the document.
The users who do not have Microsoft VSTO Runtime installed can open the document. You need to ensure that the solution meets the requirements.
Which code segment should you use?

• A.Me.ReloadAs ( Microsoft.Office.Core.MsoEncoding . _ msoEncodingAutoDetect ) Me.Save ()
• B.Me.RejectAllRevisionsShown () Me.Save ()
• C.Me.RemoveCustomization () Me.Save ()
• D.Me.RemoveTheme () Me.Save ()

You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in has a custom task pane named MyPane.
MyPane contains a user control named MyUserControl. You write the following method that resizes MyUserControl.
public void ResizeControls () {
//...
}
You need to call the ResizeControls method when MyPane is not docked to the Excel 2007 application window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Add the following method to the add-in. void DockChanged (object sender, EventArgs e) { if ( MyPane.Control.Dock == DockStyle.None ) { ResizeControls (); } }
• B.Write the following line of code in the Startup event for the add-in. MyPane.DockPositionChanged += new EventHandler ( DockChanged );
• C.Write the following line of code in the Startup event for the add-in. MyPane.Control.DockChanged += new EventHandler ( DockChanged );
• D.Add the following method to the add-in. void DockChanged (object sender, EventArgs e) { if ( MyPane.DockPosition == MsoCTPDockPosition.msoCTPDockPositionFloating ) { ResizeControls (); } }