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

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains a NamedRange control named MyRange. MyRange is associated with cell D1. You need to change MyRange to use the cells A1 and B1. Which code segment should you use?

• A.MyRange.Formula = "A1:B1";
• B.MyRange.RefersTo = "=$A$1:$B$1";
• C.MyRange.RefersTo = "A1:B1";
• D.MyRange.Formula = "=$A$1:$B$1";

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.Excel.Range rng = sheet.get_Range ("A1", "B2"); rng.Value2 = tbl.Range.Text ;
• B.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 ; } }
• 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.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 ; } }

You create a document-level solution for Microsoft Office 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the solution to a folder on a network share. You copy a new version of the solution to a subfolder of the folder. You need to ensure that the users are redirected to the new version of the solution when they open the solution from the network share. What should you do?

• A.Create a deployment manifest in the subfolder. Edit the deployment manifest in the subfolder to point to the new version.
• B.Change the application manifest in the main folder of the published solution to point to the new version.
• C.Create an application manifest in the subfolder. Edit the application manifest in the subfolder to point to the new version.
• D.Change the deployment manifest in the main folder of the published solution to point to the new version.

You create a document-level solution for a Microsoft Office Word document by using a Visual Studio Tools for the Microsoft Office System (VSTO) project. The solution project is named HRSolution. The solution document is named HRSolution.doc. You deploy a copy of the solution document to the C:\OfficeSolutions folder on client computers. You deploy the assembly to a shared folder named OfficeSolutions. The shared folder is located on a server named LONDON. You need to ensure that the solution document loads the assembly from the correct location. Which code segment should you use?

• A.ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string name = @" LONDON.OfficeSolutions.HRSolution "; sd.AppManifest.Identity.Name = name; sd.Save ();
• B.ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string path = @"\\LONDON\OfficeSolutions"; sd.AppManifest.DeployManifestPath = pa th; sd.Save ();
• C.ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string path = @"\\LONDON\OfficeSolutions"; sd.AppManifest.Dependency.AssemblyPath = path; sd.Save ();
• D.ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string name = " LONDON.OfficeSolutions.HRSolution "; sd.AppManifest.EntryPoints.Add (name); sd.Save ();

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 Word.Paragraph par =
this.Application.ActiveDocument.Paragraphs[2]; 03 par.Range.Text = ""; 04 } 05 ...
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 05?

• A.catch (IndexOutOfRangeException ex) { // }
• B.catch (IOException ex) { // }
• C.catch (COMException ex) { // }
• D.catch (InvalidRangeException ex) { // }