Exam 12: Templates, styles, and Macros

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

Custom Functions are recorded in the macro recorder.

(True/False)
4.9/5
(42)

Delete macros in the ________ dialog box.

(Short Answer)
4.9/5
(37)

The ________ directs Excel to trust files in particular folders or created by certain users.

(Short Answer)
4.8/5
(38)

You can pause the Macro Recorder in the middle of the recording process to edit mistakes.

(True/False)
4.8/5
(40)

________ is the file extension for Macro-Enabled Workbooks.

(Short Answer)
5.0/5
(42)

How many characters can an Excel password have?

(Multiple Choice)
4.8/5
(33)

What tool is best for automating the completion of repetitive tasks in Excel?

(Multiple Choice)
4.8/5
(40)

Data and Model,Titles and Headings,and Good,Bad,and Neutral are examples of predefined Cell ________.

(Short Answer)
4.8/5
(39)

Protecting a workbook encrypts it for internet transmission.

(True/False)
4.7/5
(30)

A password on a protected workbook can be ________ characters long.

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

On which tab is the Themes Gallery?

(Multiple Choice)
4.7/5
(32)

The Macro Recorder is on which two tabs?

(Multiple Choice)
4.9/5
(33)

Which of the following is not a good guideline for creating a template?

(Multiple Choice)
4.9/5
(43)

Use these instead of numbers in formulas in templates whenever possible.

(Multiple Choice)
4.9/5
(42)

What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4,if your password is ExcelIsFun?

(Multiple Choice)
5.0/5
(33)

To modify a style,right-click the style and then select ________.

(Multiple Choice)
4.8/5
(38)

Excel templates use the .xlsx file extension.

(True/False)
4.9/5
(46)
Match each of the following concepts to its best description:
Theme
A programming language for Office
VBA
Collection of colors,fonts and effects
Custom Function
Stored procedure that performs routine tasks
Correct Answer:
Verified
Premises:
Responses:
Theme
A programming language for Office
VBA
Collection of colors,fonts and effects
Custom Function
Stored procedure that performs routine tasks
Template
Partially Created Workbook
Macro
Custom programming that fulfills the user's needs
(Matching)
4.9/5
(43)

If you forget your Excel password,you can recover it with your Microsoft account password.

(True/False)
4.8/5
(34)
Showing 61 - 80 of 97
close modal

Filters

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