Exam 12: Developing an Excel Application

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control)into a worksheet?

What is the file extension of macro-enabled workbook?

Joyce wants to stop recording the steps of a task as a macro.She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save.Which of the following can X be in the given steps?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

How can you align all objects to the upper-left corner of a cell?

Which of the following must be checked after selecting Main tabs from Customize the Ribbon drop down box,to turn the Design Mode on?

To insert a list box (form control)into a worksheet,click the Developer tab > Controls group > Insert > Form Controls > Button with an up and a down arrow in two rectangular boxes,placed one below the other.

If you want to write a macro for a workbook in use,you need to first click the name of the VBA Project in the Project Explorer window.

Jean-Michelle wants to record the steps of a task as a macro.She clicks on the following series: Click View > Macros > X > Macro Name > Select list to run > Y.Which of the following can be X and Y in the given steps?

Which of the following should you select as X in the series of clicks to clear a comment from a cell: Cell containing comment > Review tab > X > Delete button?

The .NET Framework calls the Main procedure when it has loaded the application and is ready to pass control to it.

Sophia wants to change the location of a picture linked to her workbook to a different drive.To do so,she can click on the following series: Data tab > Edit links group > Select link to change > Change Source > Change Source Dialog box > Use controls in the dialog box to locate and select the file for new source of the link > Open > OK.

A new worksheet has items listed in cell range A1 to A20.Which of the following will you type in the Format Object window in the Input Range box to specify the range for the list?

Which of the following combinations of keys will you press to open the VBA window and run a macro code?

Cora wants to manually rename a new form control button with a macro assigned to it.Which of the following combination of keys can she use to select it?

To unprotect a workbook,open the Excel file,then click on Review > Unprotected Sheet,then enter the password for the unprotected sheet and click OK.

The initial screen of Visual Basic Editor provides four GUI elements: Menu bar,Toolbar,Project Explorer,and Property Window.

What value of Shadow property has an effect of Offset Right on an ActiveX control?

To insert WordArt in Excel,click on Insert > WordArt,then select the WordArt style and then replace with the desired text in the Placeholder text.

To lock certain cells in a worksheet to protect them,select the cells,then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select)Locked check box > OK to close the popup window.Then click on Review tab > Changes group > Protect Sheet.