Exam 12: Developing an Excel Application

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 keys will help you single step through your code in a macro?

To run code,use shortcut Ctrl+Alt+N.

Arlo creates a rectangular shape and inserts the text 'Color Box' in it.Then,he right clicks on the shape and selects a button to assign a macro to it.Which of the following can his selection be?

Alexa wants to insert a command button control in VBA and execute a program using the button.To do this,she clicks the option "Insert button" from the Active X Control,selects the command button option from it,then drags the mouse cursor to Excel sheet to insert "clickcommandbutton1." After this,she follows a step X.Then,she enters a code in the sheet,saves the code file,exits the editor,clicks the Excel sheet icon to the extreme left to return to the editor,turns off Design mode before clicking the Command button and executes the program.What did she do in step X in the procedure?

What should be selected in the Formula Bar to manually rename a form control button after clicking and selecting a new button?

To change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Martha and Mike are working on a project where Martha is creating a template in MS Excel that Mike will work upon. She wants to insert the message "Select True or False from the drop-down list" in a cell under a column titled "Answer." What should she select as X in the following clicks/entries/selections: (Select) cell > Data > Data Validation > Input Message > (Check box) Show input message when cell is selected > X > (Insert in box) Select True or False form the drop-down list?

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?

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she select in the Protect Workbook box under Options in the File tab to do this?

What should you select to get a finer control over the line width setting for the text of a command button (ActiveX)control?

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?

The Error Alert Style,Stop in the dropdown list that opens under Error Alert tab highlights the invalid entry that can be overtyped.

To add a toggle button (ActiveX control)into a worksheet,click the Developer tab > Insert > ActiveX Controls > Button image of concentric circles inside a rectangular box.

Mila wants to digitally sign a workbook to communicate that no further modifications should be made in the workbook.She clicks Insert tab > Text group > X > Microsoft Office Signature Line > Signature Setup Dialog box > Type Information for each box in the dialog box > Show sign date in signature line OK.What can X be in this series of clicks?

One can use the InputBox function in Excel VBA to prompt a user to enter a value.

One can select the macro one wants to edit in the Macro Name box.

To open the macro dialog box for editing a macro in Visual Basic Editor,press Alt+F8.

Which of the following will you select as X in the series to insert a button (form control)into a worksheet: Developer tab > X > Insert > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type OK in the Assign Macro popup window?

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