Online Access Free 070-543 Exam Questions

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 ( rng.EntireColumn , 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 ( ws.get_Range ("A2:A12", Type.Missing ), 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 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You install Microsoft VSTO 2005 Second Edition and Microsoft Office 2003 Professional with its default settings on computers that run Microsoft Windows XP Professional. You also install the add-in on the computers. Users report that they are unable to access the add-in. You need to configure the computers to run the add-in correctly. What should you install on the computers? (Each correct answer presents part of the solution. Choose two.)

• A.Microsoft Office 2003 Primary Interop Assemblies
• B.Microsoft .NET Framework 2.0
• C.Microsoft Visual Studio 2005
• D.Microsoft .NET Framework 1.1

You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

• A.control.LockContentControl = false; control.LockContents = false;
• B.control.LockContentControl = false; control.LockContents = true;
• C.control.LockContentControl = true; control.LockContents = false;
• D.control.LockContentControl = true; control.LockContents = true;

You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?

• A.Delete the itemProps1.xml file.
• B.Create a file named itemProps2.xml that marks the item2.xml file as a data store.
• C.Delete the item1.xml file.
• D.Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The add-in contains a Ribbon1.xml file that customizes the Ribbon user interface (UI). The Ribbon1.xml file contains the following element.
< dropDown id=" CountryCodes " getItemCount =" GetItemCount "
getItemLabel =" GetItemLabel "/>
You write the following line of code in the add-in.
Private countries As System.Collections.ArrayList
...
countries = New System.Collections.ArrayList ()
countries.Add ("USA")
countries.Add ("JPN")
countries.Add ("IND"}
You need to bind the drop-down list to the countries collection.
Which code segments should you use? (Each correct answer presents part of the solution. Choose two.)

• A.Public Overloads Function GetItemLabel ( ByVal control As _ Office.IRibbonControl , ByVal index As Integer) As String Return countries(index) End Function
• B.Public Overloads Function GetItemCount _ ( ByVal control As Office.IRibbonControl ) As Integer Return countries.Capacity End Function
• C.Public Overloads Function GetItemCount _ ( ByVal control As Office.IRibbonControl ) As Integer Return countries.Count End Function
• D.Public Overloads Function GetItemLabel ( ByVal control As _ Office.IRibbonControl , ByVal index As Integer) As String Return countries.ToString () End Function