Question 1

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

Accepted Answer

A)  Fill Effects 
B)  More Colors 
C)  Color List Box 
D)  Special Effects

Question 2

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

Accepted Answer

A)  FontBold 
B)  FontItalic 
C)  FontWeight 
D)  FontStrikeThru

Question 3

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

Accepted Answer

A)  Data 
B)  View 
C)  Review 
D)  Developer

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A)  Title 
B)  Heading 
C)  Input message 
D)  Insert message

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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?

Accepted Answer

A)  Decimal 
B)  List 
C)  Text length 
D)  Whole number

Question 8

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?

Accepted Answer

A)  Ctrl + Z 
B)  Alt + F8 
C)  Ctrl + Shift 
D)  Alt + T + M + R

Question 9

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?

Accepted Answer

A)  "A1:A20" 
B)  'A1:A20' 
C)  A1-A20 
D)  A1:A20

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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?

Accepted Answer

A)  Macros 
B)  Visual Basic 
C)  Record Macro 
D)  Macro Security

Question 12

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?

Accepted Answer

A)  All 
B)  Formats 
C)  Formulas 
D)  Validation

Question 13

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.

Accepted Answer

A) True 
 B)False

Question 14

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?

Accepted Answer

A)  Create New 
B)  Create from File 
C)  Signature line List 
D)  Add Signature Services

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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?

Accepted Answer

A)  XML group 
B)  Modify group 
C)  Controls group 
D)  Add-ins group

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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?

Accepted Answer

A)  Advance 
B)  Language 
C)  Customize Ribbon 
D)  Quick Access Toolbar

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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

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.

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

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

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.