Question 1

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?

Accepted Answer

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

Question 2

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

Accepted Answer

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. A

Question 3

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?

Accepted Answer

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

Question 4

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?

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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?

Accepted Answer

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 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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?

Accepted Answer

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 10

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

Accepted Answer

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

Question 11

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?

Accepted Answer

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

Question 12

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.
​

Accepted Answer

A) True 
 B)False

Question 13

What is the file extension of macro-enabled workbook?

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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?

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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?

Accepted Answer

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

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A) True 
 B)False

Exam 12: Developing an Excel Application

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?

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

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?

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?

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

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?

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

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

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

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?

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. ​

What is the file extension of macro-enabled workbook?

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

Which of the following will you select on the Color and Lines tab to adjust the gradient, texture, and pattern of a form 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 would you select on the Developer group to record a relative reference macro?

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?

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.

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.