Deck 12: Developing an Excel Application

Question 1

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?

A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Answer 1

B

Question 2

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.

Answer 2

False

Question 3

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?

A) Macros
B) Excel Add-ins
C) Stop Recording
D) Visual Basic Editor

Answer 3

A

Question 4

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

Question 5

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) Decimal
B) List
C) Text length
D) Whole number

Question 6

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?

A) Mark as Final
B) Encrypt with Password
C) Protect Current Sheet
D) Protect Workbook Structure

Question 7

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?

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

Question 8

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.

Question 9

To unprotect a workbook, open the Excel file, then click on Review > Unprotected Sheet, then enter the password for the unprotected sheet and click OK.
​

Question 10

Which of the following combinations of keys will you press to open the VBA window and run a macro code?

A) Alt + F9
B) Alt + F11
C) Alt + F4
D) Alt + Tab

Question 11

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) Title
B) Heading
C) Input message
D) Insert message

Question 12

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.

Question 13

Jean-Michelle wants to record the steps of a task as a macro. She clicks on the following series: Click View > Macros > X > Macro Name > Select list to run > Y. Which of the following can be X and Y in the given steps?

A) X- View Macros, Y- Run
B) X- Record Macros, Y- Run
C) X- Pause Recording, Y- Step
D) X- Pause Recording, Y- Edit

Question 14

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

Question 15

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.

Question 16

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.

Question 17

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) Ctrl + Z
B) Alt + F8
C) Ctrl + Shift
D) Alt + T + M + R

Question 18

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.

Question 19

Joyce wants to stop recording the steps of a task as a macro. She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save. Which of the following can X be in the given steps?

A) View Macros
B) Record Macros
C) Pause Recording
D) Stop Recording

Question 20

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?

A) Changes group
B) Proofing group
C) Language group
D) Comments group

Question 21

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?

A) AutoLoad (Excel)
B) Enabled (Form)
C) Locked (Form)
D) Name (Form)

Question 22

What value of Shadow property has an effect of Offset Right on an ActiveX control?

A) 1
B) 3
C) 4
D) 5

Question 23

To insert WordArt in Excel, click on Insert > WordArt, then select the WordArt style and then replace with the desired text in the Placeholder text.

Question 24

What is the file extension of macro-enabled workbook?

A) .xls
B) .xlx
C) .xlsx
D) .xlsm

Question 25

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?

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

Question 26

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?

A) Assign Macro…
B) Format Shape…
C) Set as Default Shape
D) Size and Properties…

Question 27

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?

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

Question 28

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?

A) Button image with a check inside two concentric rectangular boxes
B) Button image with an up and a down arrow in two rectangular boxes, placed one below the other
C) Button image of concentric circles inside a rectangular box
D) Button image with a tick inside a rectangular box

Question 29

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

A) F5
B) F8
C) F11
D) F12

Question 30

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?

A) Insert
B) View Code
C) Run Dialog
D) Design Mode

Question 31

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?

A) Right click on the command button and select "Format Control".
B) Right click on the command button and select "Command Button Object".
C) Right click on the command button and select "View Code".
D) Right click on the command button and select "Properties".

Question 32

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?

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

Question 33

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?

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

Question 34

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

A) Distribute Horizontally
B) Distribute Vertically
C) Distribute Evenly
D) Distribute Across

Question 35

Which of the following would you select on the Developer group to record a relative reference macro?

A) Macros
B) Visual Basic
C) Record Macro
D) Use Relative References

Question 36

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

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

Question 37

How can you align all objects to the upper-left corner of a cell?

A) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid.
B) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape.
C) Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top.
D) Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom.

Question 38

Cora wants to manually rename a new form control button with a macro assigned to it. Which of the following combination of keys can she use to select it?

A) Tab + Click
B) Ctrl + Click
C) Ctrl + Alt + Click
D) Shift + Alt + Click

Question 39

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

A) Customize Ribbon
B) Advanced
C) Language
D) Proofing

Question 40

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

A) Name Box
B) Formula box
C) Form Control box
D) Form control button box

Question 41

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

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

Question 42

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

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

Question 43

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

Question 44

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

Question 45

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

Question 46

The .NET Framework calls the Main procedure when it has loaded the application and is ready to pass control to it.

Question 47

Which of the following will you click after File > Options to open the Developer tab to change the back color of an ActiveX control?

A) Formulas
B) Proofing
C) Trust Center
D) Customize Ribbon

Question 48

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

Question 49

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?

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

Question 50

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.

Question 51

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

Question 52

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

Question 53

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.

Question 54

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

Question 55

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.

Question 56

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Question 57

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

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

Question 58

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

Question 59

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

Question 60

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?

A) Visible (Form)
B) Placement (Excel)
C) PrintObject (Excel)
D) WordWrap (Form)