1.                  A macro is

A.                  A small visual basic program

B.                 A sequence of keystrokes or actions that can be recorded

C.                 A way of automating Excel tasks

D.                 All of the above

 

 

2.                  To record a macro you should

A.                  Click the record button on the formatting toolbar

B.                 Click the record button on the standard toolbar

C.                 Choose File->Record Macro

D.                 Choose Tools->Macro->Record New Macro

 

 

3.                  Which one of the following statements is false?

A.                  You can assign a macro to a button

B.                 You can assign a macro to a form control

C.                 You can put a button for your macro on a toolbar

D.                 Macros are extremely safe and cannot perform malicious actions

 

 

4.                  A form control is not

A.                  A type of user interface component

B.                 A way to make selections from data options in a worksheet

C.                 An Excel feature designed for exchanging data over the World Wide Web

D.                 A way of controlling user input

 

 

5.                  Form controls can be found on

A.                  The Forms toolbar

B.                 The Standard toolbar

C.                 The File Menu

D.                 The status bar

 

 

6.                  A check box control returns

A.                  Numerical values

B.                 Formulas

C.                 True or False

D.                 None of the above

 

 

 

7.                  A radio button is what type of control?

A.                  Mutually exclusive

B.                 Independent

C.                 Multi-relational

D.                 B and C

 

 

8.                  You can combine form controls to

A.                  Create a basic user interface

B.                 Modify Excel’s menus

C.                 Convert worksheet documents to text files

D.                 Make array formulas unnecessary

 

 

9.                  Which one of the following statements is true?

A.                  Macros and form controls are exactly the same

B.                 A form control can do anything a macro can do

C.                 You can’t have macros and form controls in the same workbook

D.                 You can have Macros and form controls in the same workbook

 

 

10.             VBA Stands for

A.                  Visual basic algorithms

B.                 Visual basic for applications

C.                 View bottom array

D.                 None of the above