70-543 試験問題を無料オンラインアクセス

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 Sub ResizeControls ()
...
End Sub
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. Private Sub DockChanged ( ByVal sender As Object, _ ByVal e As EventArgs ) If MyPane.DockPosition = _ MsoCTPDockPosition.msoCTPDockPositionFloating Then ResizeControls () End If End Sub
• B.Add the following method to the add-in. Private Sub DockChanged ( ByVal sender As
  Object, _ ByVal e As EventArgs ) If MyPane.Control.Dock = DockStyle.None Then ResizeControls () End If End Sub
• C.Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.DockPositionChanged , AddressOf Me.DockChanged
• D.Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.Control.DockChanged , AddressOf Me.DockChanged

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Microsoft.Office.Tools.CustomTaskPane pane;
private void CreatePane () {
pane = this.CustomTaskPanes.Add (new MyUserControl (),
"Do Something");
pane.Visible = true;
}
You need to ensure that only a single instance of the custom task pane is displayed in each single document interface (SDI) window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Word.Document Doc, Word.Window Wn ) { CreatePane (); }
• B.Create the following event handler for the Application.DocumentOpen event. void Application_DocumentOpen ( Word.Document Doc) { CreatePane (); }
• C.Create the following event handler for the Application.ActiveDocument.New event. void ActiveDocument_New () { CreatePane (); }
• D.Create the following event handler for the Application.NewDocument event. void Application_DocumentNew ( Word.Document Doc) { CreatePane (); }
• E.Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }

You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a folder on a network share. The folder hosts 20 assemblies. All the assemblies are signed and contain the same digital signature. The add-in runs from a local computer. When the add-in is accessed from a network share by using th e same computer, a security exception is raised. You need to ensure that the add-in can run from the network share. You must achieve this goal without elevating permissions for the other assemblies. What should you do?

• A.Create a code group that is based on the publisher.
• B.Create a code group that is based on the network share URL.
• C.Create a code group that is based on the file hash.
• D.Create a code group that is based on the public token that is used to sign the assembly.

You are creating an application for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The application will contain a namespace named WordAddInNS.
WordAddInNS will contain the following items:
a class named WordExcelIsland
a method named GetDataIsland
a typed dataset class named WSS_DataSet
You write the following lines of code. (Line numbers are included for reference only.)
01 private void GetDataIsland (string DocPath) {
02 using (ServerDocument sd = new ServerDocument(DocPath)) {
03 CachedDataHostItemCollection HC = sd.CachedData.HostItems;
04 if (HC.Count > 0 &&
05 ...
10 ) {
12 ...
13 }
14 }
15 }
You need to load all the data islands of the type WSS_DataSet from the local document cache.
Which code segment should you insert at line 05?

• A.HC["WordAddInNS.WordExcelIsland"].Equals("WSS_DataSet"))
• B.HC["WordAddInNS.WordExcelIsland"].CachedData.Contains ( "WSS_DataSet"))
• C.HC["WordAddInNS.WordExcelIsland"].Equals ( "WordAddInNS.WSS_DataSet"))
• D.HC["WordAddInNS.WordExcelIsland"].CachedData.Contains ( "WordAddInNS.WSS_DataSet"))

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 has a table that contains data. The table has two columns and two rows.
You write the following lines of code. (Line numbers are included for reference only.)
01 Excel.Workbook book;
02 Excel.Worksheet sheet = book.Worksheets [1] as Excel.Worksheet ;
03 Word.Table tbl = this.Tables [1];
04 ...
You need to insert the data in the cell range A1 through B2 of the first worksheet in the Excel workbook.
Which code segment should you insert at line 04?

• A.for ( int i = 0; i < tbl.Rows.Count ; i ++) { for ( int j = 0; j < tbl.Columns.Count ; j++) { ( sheet.Cells [ i , j] as Excel.Range ).Value2 = tbl.Cell ( i , j). Range.Text ; } }
• B.for ( int i = 1; i < = tbl.Rows.Count ; i ++) { for ( int j = 1; j < = tbl.Columns.Count ; j++) { ( sheet.Cells [ i , j] as Excel.Range ).Value2 = tbl.Cell ( i , j). Range.Text ; } }
• C.Excel.Range rng = sheet.get_Range ("A1", System.Type.Missing ); tbl.Range.Copy (); rng.PasteSpecial ( Excel.XlPasteType.xlPasteAll , Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone , System.Type.Missing , System.Type.Missing );
• D.Excel.Range rng = sheet.get_Range ("A1", "B2"); rng.Value2 = tbl.Range.Text ;