Online Access Free 070-543 Exam Questions

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.
void DisplayTotal ( Excel.Range rng ) { //Display total }
You write the following code segment in the startup event of the add-in.
Excel.Worksheet ws = Globals.ThisAddIn.Application .
ActiveSheet as Excel.Worksheet ;
ws.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( 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.void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [0]); }
• B.void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Previous ); }
• C.void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [1]); }
• D.void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.CurrentRegion ); }

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the
Microsoft Office System (VSTO). The add-in customizes the Ribbon user interface (UI).
The add-in contains a file named Ribbon1.xml that has the following markup for two buttons.
<button id="Btn1" onAction =" DoOperation " />
<button id="Btn2" onAction =" DoOperation " />
You need to create a callback function that runs different code for the buttons.
Which code segment should you use?

• A.Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Id = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• B.Public Sub DoOperation ( ByVal control As Control) If control.ProductName.Equals ("Btn1") Then 'Btn1 click Else 'Btn2 click End If End Sub
• C.Public Sub DoOperation ( ByVal control As Control) If control.Text = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• D.Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Tag = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must connect to a remote database to retrieve data. The structure of the remote database is shown in the exhibit. (Click the Exhibit button.)
You write the following lines of code. (Line numbers are included for reference only.)
01 Partial Friend NotInheritable Class Settings
02 Inherits System.Configuration.ApplicationSettingsBase
03 < System.Configuration.SpecialSettingAttribute ( _
04 System.Configuration.SpecialSetting.ConnectionString )>
05 ...
06 Public ReadOnly Property ExcelSQLConnectionString () _
As String 07 Get 08 Return Convert.ToString (Me(" ExcelSQLConnectionString ")) 09 End Get 10 End Property 11 End Class
You need to connect to the remote database by using the security context of the current user.
Which code segment should you insert at line 05?

• A.< System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Production;Integrated Security=True")> _
• B.< System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" & _ "Integrated Security=True")> _
• C.< System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Product;Integrated Security=True")> _
• D.< System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL ;InitialCatalog = AdventureWorks ." & _ " Production.Product;Integrated Security=True")> _

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will create a local database during the installation process. The add-in will extract data from the database. The add-in must be installed only on computers that have Microsoft SQL Server 2005 Express Edition. You need to configure the default setup project for the add-in. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Add a script to the Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
• B.Add a script to the Custom Actions Editor to install the local database.
• C.Add a script to the File System Editor to install the local database.
• D.Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
• E.Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.

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.Formula = "=$A$1:$B$1"
• C.MyRange.RefersTo = "=$A$1:$B$1"
• D.MyRange.RefersTo = "A1:B1"