Exam 12: Developing an Excel Application

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 would you select on the Developer group to record a relative reference macro?

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

Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?

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?

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?

Kai wants to hide a worksheet with a password to prevent other users from viewing it.To do so,he can Click Review > Protect Workbook > Enter a password in the Password box > OK.He can then retype the password to confirm it,and then click OK.

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

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

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 unprotect a workbook,open the Excel file,then click on File > Info > Protect Workbook > Encrypt with Password > OK.

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?

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.

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

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?

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

You can open the VBA editor with the keyboard shortcut Alt + F11.

Which of the following will you click after the following series to distribute form controls horizontally: Select controls > Drawing Tools Format tab > Align?