Deck 11: Using Macros and Visual Basic for Applications Vba With Excel

Question 1

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

A) workbook
B) document manager
C) command line
D) dialog report

Answer 1

A

Question 2

Which of the following commands can you use to replace a formula with a text value?

A) Paste Text Box
B) Paste Summary
C) Paste Formulas
D) Paste Values

Answer 2

D

Question 3

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

A) password
B) formula
C) precedent
D) dependent

Answer 3

A

Question 4

Which of the following is the path to the Record Macro button?

A) (FORMULAS tab | Execute Macro group)
B) (DEV

Question 5

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

A) blister
B) patch
C) virus
D) fever

Question 6

You can add the DEV

Question 7

Which of the following is the path to the Macro Security button?

A) (FORMULAS tab | Security group)
C) (DEV

Question 8

Pressing ____ displays formulas in worksheet cells.

A) CTRL+SINGLE QUOTE (')
B) CTRL+TILDE (~)
C) CTRL+COMMA (,)
D) CTRL+ACCENT MARK (`)

Question 9

You can enable or disable macros with options in the ____ dialog box.

A) Macro Options
B) Trust Center
C) Excel Options
D) Security Center

Question 10

____ are particularly helpful when working with a series of columns that would otherwise require you to scroll horizontally, or when entering a large number of entries into a worksheet.

A) Control buttons
B) Data forms
C) Command buttons
D) Macro recorders

Question 11

The Protect Sheet button is located on the ____ tab.

A) CODE
C) DEV

Question 12

A series of precise instructions for a computer to accomplish a task is called a ____.

A) formula
B) description
C) procedure
D) report

Question 13

A macro name can be up to ____ characters long.

A) 8
B) 32
C) 127
D) 255

Question 14

Which of the following is the path to the Unprotect Sheet button?

A) (FORMULAS tab | Changes Auditing group)
B) (REVIEW tab | Changes group)
C) (HOME tab | Changes group)
D) (DATA tab | Changes group)

Question 15

Which of the following functions can you use to determine the position of the space that separates a first and last name?

A) SEARCH
B) LEN
C) LEFT
D) RIGHT

Question 16

An Excel ____ is a procedure composed of VBA code.

A) micro
B) list
C) macro
D) table

Question 17

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

A) CASE
B) TEXT
C) UPPER
D) PROPER

Question 18

If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEV

Question 19

Use macros to ensure consistency in all of the following EXCEPT ____.

A) calculations
B) formatting
C) manipulation of nonnumeric data
D) variables

Question 20

A ____ is created by performing a set of steps and recording the steps as they are performed.

A) table
B) macro
C) report
D) calculation

Question 21

You can reset the Quick Access Toolbar to its installation default by tapping or clicking the Reset button in the Customize Quick Access Toolbar options in the ____ dialog box.

A) Installation Defaults
B) Restore Settings
C) Factory preset
D) Excel Options

Question 22

____ controls provide great flexibility in terms of their design.

A) Option Button
B) Form
C) Command Button
D) ActiveX

Question 23

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

A) Delete
B) Remove
C) Cut
D) Edit

Question 24

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.

A) viruses
B) beacons
C) errors
D) agents

Question 25

Which of the following is the default security option for workbooks containing macros?

A) Disable all macros with notification
B) Enable all macros
C) Disable all macros except digitally signed macros
D) Disable all macros without notification

Question 26

The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.

A) Visual Basic Recorder
B) Visual Basic Interpreter
C) Visual Basic Editor
D) none of the above

Question 27

Which of the following is the path to the 'Create from Selection' button used to assign names to cells and enter necessary references?

A) (DEV

Question 28

Signed macros based on your own digital certificate are called ____.

A) commercially-signed projects
B) dynamically managed projects
C) self-signed projects
D) none of the above

Question 29

You can use the ____ form control to position a set of option buttons together.

A) Group Box
B) Spin Button
C) Label
D) Scroll Bar

Question 30

Each ActiveX control available in the Controls gallery has many ____.

A) properties
B) facets
C) names
D) none of the above

Question 31

____ controls require no knowledge of VBA to be used.

A) Dynamic object
B) Form
C) ActiveX
D) Worksheet management

Question 32

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.

A) Format Borders and Fill
B) Format Control
C) Format Object
D) Format Options

Question 33

In which of the following modes can you set the properties that determine a control's appearance and behavior?

A) Run
B) Design
C) Execute
D) Modify

Question 34

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

A) (DEV

Question 35

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.

A) procedure
B) process
C) desk
D) instruction

Question 36

Comments can be placed at any of the following positions EXCEPT ____.

A) in between lines of code
B) before the Supplement statement
C) at the end of a line of code
D) before the Sub statement

Question 37

A ____ is an attachment to a file or email message that vouches for its authenticity.

A) digital comment
B) digital certificate
C) certification authority
D) digital signature

Question 38

____ code is created automatically by the macro recorder.

A) ABC
B) VBA
C) XTM
D) RCC

Question 39

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

A) CTRL+I
B) CTRL+G
C) CTRL+F
D) CTRL+J

Question 40

It is good practice to place comments containing overall documentation and information before the ____ statement.

A) Sub
B) Supplement
C) Public
D) Rem

Question 41

Which of the following are names for a step-by-step description of a computerized task?

A) code
B) program
C) outline
D) procedure

Question 42

Passwords in Excel can contain ____.

A) letters
B) numbers
C) spaces
D) up to 30 characters

Question 43

Cells must be locked and the worksheet unprotected to restrict what users can do to cell contents.

Question 44

You can click the Stop/Start Macro button on the status bar to start or stop recording a macro.

Question 45

The MACRO tab on the ribbon includes commands used to work with macros.

Question 46

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Question 47

Usually all cells in a workbook are unlocked, except for those in which you enter data.

Question 48

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Question 49

Before recording a macro, you should select your ending cell.

Question 50

A macro's steps and their order should be determined and rehearsed after creating the macro.

Question 51

A macro name can contain numbers and letters but not underscores.

Question 52

Which of the following are true about macros?

A) They save time
B) They ensure consistency
C) They automate repetitive tasks
D) They reduce formatting conformity

Question 53

Once you start recording a macro, any task you perform in Excel will be part of the macro.

Question 54

Which of the following steps must be taken in preparation for working with macros in Excel?

A) The DEV

Question 55

If you make a mistake while recording a macro, press the ESC key and repeat the step in error.

Question 56

The basics of using VBA to create a data entry form include ____.

A) adding a button to the Create Code toolbar
B) creating a user interface
C) setting the properties
D) writing the code

Question 57

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

Question 58

You should select the ending cell before turning on the macro recorder.

Question 59

Excel has a command or button for every possible worksheet task.

Question 60

If you lose an Excel password, you can request the password from Microsoft in order to gain access to the password-protected worksheet.

Question 61

ActiveX controls can be assigned an Excel macro directly.

Question 62

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.
_________________________

Question 63

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Question 64

Excel provides a code generator called a(n) _________________________.

Question 65

With a worksheet protected, you can modify the contents of cells regardless of whether they are locked or unlocked.
_________________________

Question 66

Because Excel does not have a command or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5.
_________________________

Question 67

An event-driven program includes procedures that are executed when specific actions are taken by the user or other events occur.

Question 68

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the code is not executable.

Question 69

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

Question 70

When a user interacts with a control, the Visual Basic code that is associated with that action is executed.

Question 71

You can _________________________ a cell containing a formula or function to activate Range Finder.

Question 72

You can add up to 15 buttons to the Quick Access Toolbar.

Question 73

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Question 74

Excel's data form feature is used for entering data when the content is straightforward text or numbers. _________________________

Question 75

You can use Range Finder or the auditing commands to show which cells are referenced in formulas and functions.
_________________________

Question 76

Excel passwords are _________________________ sensitive.

Question 77

The process of writing a procedure is called _________________________.

Question 78

A(n) ____________________ like the one in the accompanying figure is created from a range of cells, and uses the column headings from that range to create the fields on the form.

Question 79

Form controls and ActiveX controls look identical and function in the same way.

Question 80

You cannot assign an Excel macro directly to a form control.