Question 1

Which of the formats below will not support sub procedures using VBA?

Accepted Answer

A) .xlsm 
B) .xlsx 
C) .xlsb 
D) .xltm 
A) .xlsm 
B) .xlsx 
C) .xlsb 
D) .xltm

Question 2

The VBA editor can be access using the keystroke combination ________.

Accepted Answer

The answer of The VBA editor can be access using...

Question 3

By default all cells are locked.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of A ________ is a partially completed document...

Question 5

Where is the Protect Sheet command located in the Ribbon?

Accepted Answer

A) Backstage 
B) Formulas tab 
C) Review tab 
D) Data tab 
A) Backstage 
B) Formulas tab 
C) Review tab 
D) Data tab

Question 6

Which of the following is not an Office theme?

Accepted Answer

A) Office 
B) Integral 
C) Helvetica 
D) Frame 
A) Office 
B) Integral 
C) Helvetica 
D) Frame

Question 7

Which of the following is not true about locked cells?

Accepted Answer

A) Locked cells can be edited 
B) All cells are locked by default 
C) A password is required to unlock the cells 
D) A locked cell is indicated by a padlock icon in the Format menu 
A) Locked cells can be edited 
B) All cells are locked by default 
C) A password is required to unlock the cells 
D) A locked cell is indicated by a padlock icon in the Format menu

Question 8

The VBA editor can be opened with the key stroke Alt+F11.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a default cell style?

Accepted Answer

A) Standard 
B) Bad 
C) Good 
D) Neutral 
A) Standard 
B) Bad 
C) Good 
D) Neutral

Question 10

An image used to classify a document as confidential can be placed as a custom ________ in a workbook.

Accepted Answer

The answer of An image used to classify a document...

Question 11

The macro recorder can append a previously recorded macro.

Accepted Answer

A) True 
 B)False

Question 12

Macro settings cannot be edited in the Trust Center.

Accepted Answer

A) True 
 B)False

Question 13

By default all cells in a workbook are ________.

Accepted Answer

The answer of By default all cells in a workbook...

Question 14

Which of the following tabs contains Form Controls?

Accepted Answer

A) Insert 
B) Data 
C) Developer 
D) Formulas 
A) Insert 
B) Data 
C) Developer 
D) Formulas

Question 15

What are the benefits of using macros?

Accepted Answer

Macros have the ability to automatically

Question 16

.xlsb files do not support macros.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Locked cell
Unlocked cell
Unprotected worksheet
Protected worksheet
Password

Accepted Answer

The Answer of When the worksheet is protected,these cells are is...

Question 18

Which of the following are used in VBA to leave notes or instructions regarding the macro?

Accepted Answer

A) Comments 
B) Keywords 
C) Indicators 
D) Index notes 
A) Comments 
B) Keywords 
C) Indicators 
D) Index notes

Question 19

What are the benefits if using templates in the workplace?

Accepted Answer

Templates serve the dual purpose of incr

Question 20

Which of the following tools is best suited to complete repetitive tasks in Excel?

Accepted Answer

A) Macros 
B) Templates 
C) Styles 
D) Themes 
A) Macros 
B) Templates 
C) Styles 
D) Themes

Exam 43: Templates styles and Macros

Which of the formats below will not support sub procedures using VBA?

The VBA editor can be access using the keystroke combination ________.

By default all cells are locked.

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

Where is the Protect Sheet command located in the Ribbon?

Which of the following is not an Office theme?

Which of the following is not true about locked cells?

The VBA editor can be opened with the key stroke Alt+F11.

Which of the following is not a default cell style?

An image used to classify a document as confidential can be placed as a custom ________ in a workbook.

The macro recorder can append a previously recorded macro.

Macro settings cannot be edited in the Trust Center.

By default all cells in a workbook are ________.

Which of the following tabs contains Form Controls?

What are the benefits of using macros?

.xlsb files do not support macros.

Which of the following are used in VBA to leave notes or instructions regarding the macro?

What are the benefits if using templates in the workplace?

Which of the following tools is best suited to complete repetitive tasks in Excel?

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