Microsoft 070-543 Actual Free Exam Questions & Community Discussion

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized worksheet must have a button in a cell of the first row and the first column. The button must be automatically resized when the cell is resized. You need to create a button that meets the requirements. Which code segment should you use?

You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must be installed on 100 computers that run Windows Vista and Microsoft Office 2007 Professional Edition. You need to configure the computers to run the add-in. What should you install on the computers?

You create a document-level solution by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution uses an assembly named MyAssembly. MyAssembly is located in the C:\Assemblies\ folder. A Microsoft Office Word 2003 document named MyWordDocument is located in the C:\Documents\ folder. You need to associate MyAssembly with MyWordDocument if managed extensions are enabled in MyWordDocument. Which code segment should you use?

You create a custom workbook for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook contains the following data:
Static data
Data that is imported from .xml files
The workbook displays the imported data by using mapped ranges.
You need to send only the imported data to a user.
What should you do?

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?

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 code that customizes the Ribbon user interface (UI). You run the add-in. The add-in does not customize the Ribbon UI and does not display an exception. You need to display the exceptions in the user interface of the add-in when the add-in starts. What should you do?

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?

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 internal sealed partial class Settings : 02 global::System.Configuration.ApplicationSettingsBase { 03 [ global::System.Configuration.SpecialSettingAttribute ( 04 global::System.Configuration.SpecialSetting.ConnectionString )]
05 ...
06 public string ExcelSQLConnectionString {
07 get {
08 return (string)(this[" ExcelSQLConnectionString "]);
09 }
10 }
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?

You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?