Exam 12: Templates, Styles, and Macros

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

What color are comments in VBA?

(Multiple Choice)
4.9/5
(33)

A(n)________ is a container in which VBA code is stored.

(Short Answer)
4.8/5
(49)

Functions are edited in the ________.

(Short Answer)
4.8/5
(40)

A forgotten ________ in Excel is unrecoverable.

(Short Answer)
5.0/5
(41)

Themes alter formulas.

(True/False)
4.8/5
(39)

Keywords are words or symbols that are reserved for specific actions in VBA.

(True/False)
4.8/5
(35)
Match each of the following terms to its best description:
Password
A worksheet in which locked cells cannot be edited
Unprotected worksheet
Up to 255 characters to unlock a protected worksheet
Locked Cell
Cells that can be edited in a protected worksheet
Correct Answer:
Verified
Premises:
Responses:
Password
A worksheet in which locked cells cannot be edited
Unprotected worksheet
Up to 255 characters to unlock a protected worksheet
Locked Cell
Cells that can be edited in a protected worksheet
Unlocked Cell
The default state for all worksheets
Protected worksheet
Uneditable when protected
(Matching)
4.7/5
(22)

There are many templates available online.

(True/False)
4.7/5
(35)
Correctly match the following File extensions to its best description of file type:
.xlsx
Macro enabled workbook template
.xls
Excel 97-2003 workbook
..xltm
Macro enabled workbook
Correct Answer:
Verified
Premises:
Responses:
.xlsx
Macro enabled workbook template
.xls
Excel 97-2003 workbook
..xltm
Macro enabled workbook
.xlsm
Excel workbook
.xltx
Excel Workbook template
(Matching)
4.8/5
(31)

Macro Buttons in worksheets are ________ buttons available on the Developer tab.

(Short Answer)
4.8/5
(24)

A user can modify a cell style.

(True/False)
4.8/5
(36)

To make a comment line in VBA, start the line with ________.

(Short Answer)
4.9/5
(25)

If you want to place Confidential behind the data in a worksheet, you use a custom ________.

(Short Answer)
4.9/5
(43)

Which of the following is false about recording a macro?

(Multiple Choice)
4.8/5
(31)

The Macro Recorder is on which two tabs?

(Multiple Choice)
4.9/5
(37)

Images or other objects can serve as buttons to run macros.

(True/False)
4.8/5
(34)

Use the ________ function to trap errors when creating templates.

(Short Answer)
4.8/5
(29)
Showing 81 - 97 of 97
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)