Module 12

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?

A1:A20

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?

Assign Macro...

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

Customize Ribbon

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

Customize Ribbon

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?

Data Validation

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

Developer

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?

Macros

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

Not: Alt + F9

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?

Not: Button image with a tick inside a rectangular box

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?

Not: Protect Current Sheet

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?

Placement (Excel)

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?

Signature line List

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

True

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. T or F

True

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

True

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

True

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

Use Relative References

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?

Whole number

What is the file extension of macro-enabled workbook?

xlsm