Exam 12: Developing an Excel Application

Kahir wants to delete a macro. To do this, he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box. Which of the following will he select as X in this series of selections?

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

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?

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?

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

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 combinations of keys will you press to open the VBA window and run a macro code?

Which of the following will you click after File > Options to open the Developer tab to change the back color of an ActiveX control?

Which of the following should be selected as X in the series of clicks to insert a check box (form control) into a worksheet: Developer tab > Controls group > Insert > Form Controls > X?

Which of the following will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?

Which of the following should be selected as X in the series to assign a macro to a button: Developer tab > Controls group > X > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type in the Assign Macro popup window?

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. ​

What is the file extension of macro-enabled workbook?

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

Which of the following will you select on the Color and Lines tab to adjust the gradient, texture, and pattern of a form control?

Which of the following properties is used to specify the way the control is attached to the cells below it, while inserting a command button (ActiveX control) into a worksheet?

Which of the following would you select on the Developer group to record a relative reference macro?

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?

Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements. To do so, she can first unlock editable cells, then click Review tab > Protect Sheet > Allow all users of this worksheet to list > Select the elements you want people to be able to change > OK.

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.