Exam 12: Developing an Excel Application

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

The initial screen of Visual Basic Editor provides four GUI elements: Menu bar, Toolbar, Project Explorer, and Property Window.

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

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?

To insert a list box (form control) into a worksheet, click the Developer tab > Controls group > Insert > Form Controls > Button with an up and a down arrow in two rectangular boxes, placed one below the other.

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?

Which of the following keys will help you single step through your code in a macro?

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.

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?

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 should you select as X in the series of clicks to clear a comment from a cell: Cell containing comment > Review tab > X > Delete button?

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

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?

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

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

To lock certain cells in a worksheet to protect them, select the cells, then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select) Locked check box > OK to close the popup window. Then click on Review tab > Changes group > Protect Sheet.

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

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

To unprotect a workbook, open the Excel file, then click on File > Info > Protect Workbook > Encrypt with Password > OK.

Sophia wants to change the location of a picture linked to her workbook to a different drive. To do so, she can click on the following series: Data tab > Edit links group > Select link to change > Change Source > Change Source Dialog box > Use controls in the dialog box to locate and select the file for new source of the link > Open > OK.