FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to copy selected content.

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

The process of writing a procedure is called _________________________.

Correct Answer

verified

computer p...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An attachment to a file or email message that vouches for its authenticity, for example.

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

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

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

Comments added to code begin with the word __________________________ or an apostrophe.

_________________________ a macro causes Excel to step through all of the recorded steps just as they were recorded.

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

How do you familiarize yourself with a workbook created by someone else?

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

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

If you are confident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

Excel includes a(n) ________________________ that can record a series of actions and save them as a macro.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A procedure comprised of VBA code.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -You can obtain a digital certificate from this.

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

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