Match between columns Premises: Background Template gallery Theme Template Cell style

The Answer of Provides the ability to search and download is...

Match between columns Premises: Visual Basic for Applications Keyword Comment Module Sub procedure

The Answer of A file in which macros are stored is...

Match between columns Premises: Run Time Error Object Sub procedure Visual Basic for Applications Module

The Answer of A variable that contains both data and is...

Exam 43: Templates styles and Macros

Comments cannot be viewed in the VBA editor.

(True/False)

4.8/5

(34)

Question 81

By default,the Developer tab is ________.

(Short Answer)

4.9/5

(39)

Question 82

Match the following terms with the corresponding description:

Background

Provides the ability to search and download Excel templates

Template gallery

An image placed behind the worksheet data

Theme

A partially completed document that you use as a model to create other documents that have the same structure and purpose

Correct Answer:

Verified

Background

Template gallery

Theme

Template

Cell style

(Matching)

4.8/5

(38)

Question 83

Once created,macro buttons cannot be deleted.

(True/False)

4.8/5

(30)

Question 84

Recorded macros can be viewed in the ________.

(Short Answer)

4.8/5

(45)

Question 85

Which of the following is not controlled with cell style formats?

(Multiple Choice)

4.7/5

(33)

Question 86

A run time error will occur if a sub procedure is run on a protected workbook.

(True/False)

4.8/5

(29)

Question 87

Which of the following is not a tool to help provided a unified look and feel within a workbook?

(Multiple Choice)

4.9/5

(30)

Question 88

Form controls are located on the Developer tab.

(True/False)

4.9/5

(34)

Question 89

Match the following terms with the corresponding descriptions:

Macro Recorder

Visual Basic scripts that perform actions

Module

Specialized functions created within VBA that can be used within a worksheet

Visual Basic for Applications

A file in which macros are stored

Correct Answer:

Verified

Macro Recorder

Module

Visual Basic for Applications

Custom function

Sub procedure

(Matching)

4.9/5

(43)

Question 90

Match the following terms to the corresponding description:

Visual Basic for Applications

A file in which macros are stored

Keyword

A Visual Basic script that performs actions

Comment

Indicated by an apostrophe and appear in green,provide information about the macro but do not affect its execution and are considered documentation

Correct Answer:

Verified

Visual Basic for Applications

Keyword

Comment

Module

Sub procedure

(Matching)

4.8/5

(34)

Question 91

What is the password character limit in Excel?

(Multiple Choice)

4.8/5

(31)

Question 92

Where is the Insert Background feature located?

(Multiple Choice)

4.7/5

(41)

Question 93

Comments in VBA appear in what color?

(Multiple Choice)

4.9/5

(37)

Question 94

Which of the following is the proper beginning for a sub procedure named "Test"?

(Multiple Choice)

4.9/5

(35)

Question 95

The Themes gallery is located on the ________ tab.

(Short Answer)

4.9/5

(32)

Question 96

Where is the Themes gallery located?

(Multiple Choice)

4.8/5

(32)

Question 97

Match the following terms to the corresponding description:

Run Time Error

A variable that contains both data and code and represents an element of Excel such as Range or Selection

Object

A file in which macros are stored

Sub procedure

A software or hardware problem that prevents a program from working correctly

Correct Answer:

Verified

Run Time Error

Object

Sub procedure

Visual Basic for Applications

Module

(Matching)

4.7/5

(35)

Question 98

Macros are stored in modules.

(True/False)

4.9/5

(35)

Question 99

By default,macros in Excel are ________.

(Short Answer)

4.8/5

(39)

Question 100

Exam 43: Templates styles and Macros

Comments cannot be viewed in the VBA editor.

By default,the Developer tab is ________.

Once created,macro buttons cannot be deleted.

Recorded macros can be viewed in the ________.

Which of the following is not controlled with cell style formats?

A run time error will occur if a sub procedure is run on a protected workbook.

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Form controls are located on the Developer tab.

What is the password character limit in Excel?

Where is the Insert Background feature located?

Comments in VBA appear in what color?

Which of the following is the proper beginning for a sub procedure named "Test"?

The Themes gallery is located on the ________ tab.

Where is the Themes gallery located?

Macros are stored in modules.

By default,macros in Excel are ________.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters