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 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?

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.
Private Pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub ThisAddIn_Startup _
(ByVal sender As Object, ByVal e As System.EventArgs)
Pane = Me.CustomTaskPanes.Add _
(New MyUserControl(), "Do Something")
End Sub
You need to display the custom task pane when text is selected in a Word document.
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 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.)

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?

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 are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customization contains a predefined schema to validate the data that users add. The path to the schema is stored in a variable named filename. The Unique Resource Identifier (URI) for the schema is stored in a variable named uri. The alias for the schema is stored in a variable named alias.
You need to ensure that the schema that the user selects is applied to the solution document. Which code segment should you use?

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The document is customized to add a toolbar with custom functionality. You write the following lines of code in the Startup event of the ThisDocument class.
Dim toolbar As Office.CommandBar = Me.Application . _ CommandBars.Add (Name:=" MyToolBar ", _ Position:= Office.MsoBarPosition.msoBarTop , Temporary:=False)
Dim button As Office.CommandBarButton = _ CType ( too lbar.Controls.Add ( _ Type:= Office.MsoControlType.msoControlButton , _ Temporary:=False), Office.CommandBarButton )
Dim btnClick As _ Office._CommandBarButtonEvents_ClickEventHandler = _ AddressOf Me.button_Click
AddHandler button.Click , AddressOf Me.b utton_Click The event handler for the button does not execute every time CommandBarButton is clicked.
You need to ensure that the event handler executes every time CommandBarButton is clicked.
What should you do?

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You create the following objects in the solution:
a DataSet object named AWDataSet that contains two tables named Product and SalesOrderDetail
a BindingSource object named ProductsBindingSource
a bookmark that is bound to the SalesOrderDetail table You need to retrieve the active row from the solution .
Which code segment should you use?

You are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO).
You create the following objects in the add-in:
a DataSource object named ExpenseBindingSource
a TableAdaptor object named ExpenseTableAdapter
a DataSet object named ExpenseData
a CachedDataItem object named DI
The ExpenseData object contains a table named Expenses. The DI object contains a data island of the ExpenseData object.
You need to ensure that any changes in the content of the DI object are updated in the Expenses table.
Which code segment should you use?