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?

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

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

A Function procedure uses the Return statement to specify the return value, and returns control immediately to the calling program.

Mila wants to restrict a cell to accept only whole numbers between 1 and 100. What should she select as X in the following clicks/entries/selections: Select cell. Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select) between > Minimum > (select) 1 > Maximum > (select) 10 > OK > Enter number between 1 and 100 in cell?

Esperanza wants to record a macro to automate a repetitive task. Which of the following combinations of keys should she press to open the Macro name box?

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?

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.

Nathan wants to run a macro from the developer tab. He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run. What should he click as X in this procedure?

Which of the following should you select as X after selecting the cell to which the validation rule applies, pressing Ctrl + C, then selecting the cell you want to validate, right clicking it, clicking Paste Special, and then selecting X from the context menu and then clicking OK?

To share a protected workbook, place it on a network location, then click Review > Share Workbook > Editing tab > (Select) Allow changes by more than one user > Advanced tab > (Select) options for tracking and updating changes > OK > File > Save As > Share.

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?

To insert a spin button(form control) into a worksheet, click the Developer tab > Insert > Form Controls > Button labeled as "Aa."

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?

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

Grace wants to insert a Form control button into a worksheet. Which of the following will she select as X in the following series of clicks/entries/selections to display the Developer tab: File menu > Options from drop down menu > X in Excel Options Window > Developer checkbox under the list of Main Tabs > OK?

To insert an If Then statement into a VBA macro, type: If [condition is true] Then.

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