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 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

You can play back a macro, or _________________________ it, as often as you want to repeat the steps you recorded.

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

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

ActiveX controls can be assigned an Excel macro directly.

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

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

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

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

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.

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

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used by All Office applications to enter, modify, and view VBA code.

To make a macro available to use in any workbook, you should store the macro in the _________________________.

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

____ code is created automatically by the macro recorder.