Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

The instructions developed by users in Excel are not called:
A)programs.
B)macros.
C)procedures.
D)execution cells.
2

The Macro Recorder tool:
A)plays back Visual Basic macros.
B)captures keystrokes and converts them to Visual Basic macros.
C)generates macros in its own special language.
D)allows users to embed sounds in the spreadsheet.
3

Macros should be generated for all of the following reasons except:
A)to improve appearance of a worksheet.
B)the workbook is used regularly.
C)the same actions are done repeatedly in the workbook.
D)the workbook needs to be used by Excel novices.
4

By storing a macro in the Personal Macro Workbook:
A)you have to run the Personal Macro Workbook to use the macro.
B)the macro is automatically stored in any new workbook you generate.
C)you make the macro available to all of your workbooks.
D)the macro is not accessible to other users.
5

You can run a macro by:
A)assigning it to a button.
B)assigning it to a format command.
C)assigning it to a cell.
D)assigning it to a cursor.
6

Because the Personal Macro Workbook is hidden:
A)the macros are not available to other worksheets.
B)it should be used to store confidential data.
C)it is not generally used.
D)you must unhide it to view or edit its macros.
7

Enabling macro security:
A)is not necessary when you receive a workbook from a friend.
B)means that workbooks containing macros cannot be opened.
C)provides a way of protecting yourself from macros that contain viruses.
D)allows macros to be checked for a virus as they are being run.
8

The Visual Basic Editor:
A)allows you to maintain and improve macros created by the Macro Recorder.
B)is generally unnecessary when working with macros.
C)should not be used to build a macro from scratch.
D)allows scripts to modify Excel spreadsheets.
9

A custom function:
A)is always a Visual Basic procedure.
B)cannot be used in a worksheet cell.
C)has a function name and arguments.
D)only can work with custom data.
10

The primary disadvantage of using the macro recorder is that:
A)it is slower than writing the procedure directly.
B)it cannot record If tests and cannot create loops.
C)it ignores mouse movements.
D)the code it generates is difficult for a new user to read.
11

A VBA procedure is similar to an Excel function.
A)True
B)False
12

A function returns a value.
A)True
B)False
13

Macros are a type of VBA procedure.
A)True
B)False
14

A module is an Excel object used for storing macros, procedures, and functions.
A)True
B)False
15

Macros must be assigned to buttons before they can be used.
A)True
B)False
16

The Personal.xls is a special workbook that stores macros that can be available to all other workbooks.
A)True
B)False
17

Once a macro is recorded, it cannot be deleted.
A)True
B)False
18

The Visual Basic Editor is not necessary if you are careful when using the macro recorder.
A)True
B)False
19

The "If-then" structure allows a procedure to perform a loop.
A)True
B)False
20

Input boxes are a useful tool for getting data from the user.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


haagoffice2eOnline Learning Center

Home > Excel > Chapter 12 > Multiple Choice Quiz