Question 1

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

Accepted Answer

The Controls group contains various form controls, including the button form control, which can be inserted into a worksheet using the given steps. The other options (XML group, Modify group, Add-ins group) do not contain the button form control.

Question 2

To insert a scroll bar (form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "A."

Accepted Answer

To insert a scroll bar (form control) into a worksheet, you would click the Developer tab > Insert > Form Controls, and then select the scroll bar option, not a button labeled as "A."

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?
A) Data
B) View
C) Review
D) Developer

Accepted Answer

After selecting Main tabs from Customize the Ribbon drop down box, to turn on the Design Mode, one must check the Developer tab.

Question 4

Return value comments help others understand what values are returned by a procedure.

Accepted Answer

Return value comments are important for documenting what values are returned by a procedure, which helps other programmers understand and use the code effectively.

Question 5

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

Accepted Answer

The InputBox function can be used in Excel VBA to prompt the user to enter a value.

Question 6

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.

Accepted Answer

To insert a list box (form control) into a worksheet, you should click the Developer tab > Controls group > Insert > Form Controls, and then select the List Box option, which is represented by an icon with lines representing list items, not a button with up and down arrows. The up and down arrows in two rectangular boxes describe the Spin Button control, not the List Box.

Question 7

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

Accepted Answer

This is the correct syntax for inserting an If Then statement in VBA macro.

Question 8

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)

Accepted Answer

The Placement property is used to specify the way the control is attached to the cells below it when inserting an ActiveX control button into a worksheet. The Visible property determines whether the control is visible or hidden. The PrintObject property determines whether the control should be printed with the worksheet. The WordWrap property is not relevant to inserting a command button.

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?
A) "A1:A20"
B) 'A1:A20'
C) A1-A20
D) A1:A20

Accepted Answer

The correct syntax for specifying a range of cells in Excel is with a colon (:) between the starting and ending cell references, without any quotes or apostrophes. Therefore, the best choice is D) A1:A20.

Question 10

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

Accepted Answer

Opening the Customize Ribbon option will allow you to add the Developer tab to the Ribbon, which will give you access to the option to change the back color of an ActiveX control. The Formulas and Proofing options will not have the Developer tab, and the Trust Center is not relevant to this task.

Question 11

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

Accepted Answer

To insert a spin button (form control) into a worksheet, you click the Developer tab > Insert > Form Controls, and then select the spin button control, not a button labeled as "Aa," which typically represents a text or label control.

Question 12

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

Accepted Answer

The Fill Effects option on the Color and Lines tab allows you to adjust the gradient, texture, and pattern of a form control.

Question 13

To insert an option button into a worksheet,click on the following series: Developer tab > Insert > Form Controls > Image with a tick inside a rectangular box.

Accepted Answer

To insert an option button into a worksheet, you should click on Developer tab > Insert > Form Controls, and then choose the option button (circle with a dot inside), not an image with a tick inside a rectangular box.

Question 14

Which of the following should be clicked to change the caption of a control after right-clicking on it?
A) Order
B) Grouping
C) Properties
D) Format Control

Accepted Answer

To change the caption of a control after right-clicking on it, one should click on Properties. This option allows for various properties of the control to be changed including the caption. Options such as Order, Grouping, and Format Control do not offer the ability to change the caption of a control.

Question 15

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

Accepted Answer

This is true. A Function procedure is designed to return a value, which is done using the Return statement, and then immediately passes control back to the calling program.

Question 16

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

Accepted Answer

FontWeight determines the thickness of the text. By adjusting the FontWeight property, you can specify a specific value for the thickness of the text in the command button. This will give you finer control over the line width setting for the text in the control.

Question 17

What value of Shadow property has an effect of Offset Right on an ActiveX control?
A) 1
B) 3
C) 4
D) 5

Accepted Answer

According to Microsoft's documentation, a Shadow property value of 4 will create an offset to the right for an ActiveX control's shadow.

Question 18

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.

Accepted Answer

To add a toggle button (ActiveX control) into a worksheet, you should click the Developer tab > Insert > ActiveX Controls, and then select the toggle button control, which is represented by an icon showing a button with two states (not concentric circles inside a rectangular box). The icon with concentric circles inside a rectangular box typically represents a different control, such as an option button or radio button.

Question 19

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

The answer of If you want to write a macro...

Question 20

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

Accepted Answer

The answer of Which of the following should be selected...

Quiz 11: User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

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 insert a scroll bar (form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "A."

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

Return value comments help others understand what values are returned by a procedure.

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

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.

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

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

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

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 on the Color and Lines tab to adjust the gradient,texture,and pattern of a form control?

To insert an option button into a worksheet,click on the following series: Developer tab > Insert > Form Controls > Image with a tick inside a rectangular box.

Which of the following should be clicked to change the caption of a control after right-clicking on it?

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

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

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

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.

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.

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?