Question 1

Templates can be located and downloaded in the templates gallery.

Accepted Answer

A) True 
 B)False

Question 2

Custom backgrounds can be applied to Excel worksheets.

Accepted Answer

A) True 
 B)False

Question 3

Which function should be used to mask zero values in templates?

Accepted Answer

A) IF 
B) IFERROR 
C) VLOOKUP 
D) INDEX 
A) IF 
B) IFERROR 
C) VLOOKUP 
D) INDEX

Question 4

Which of the following formats is supported as a background in Excel?

Accepted Answer

A) jpeg 
B) mp3 
C) .xls 
D) .mpeg4 
A) jpeg 
B) mp3 
C) .xls 
D) .mpeg4

Question 5

What business practices should be used when creating a macro?

Accepted Answer

When creating a macro using the Macro Re

Question 6

Which of the following is not a best practice when creating a macro?

Accepted Answer

A) Practice the steps before starting 
B) Determine whether absolute or relative references should be used 
C) Start and stop the recording as needed 
D) Ensure the macros are broad enough to apply to multiple situations 
A) Practice the steps before starting 
B) Determine whether absolute or relative references should be used 
C) Start and stop the recording as needed 
D) Ensure the macros are broad enough to apply to multiple situations

Question 7

Where are Trust Center options located?

Accepted Answer

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

Question 8

By default,the macro recorder uses absolute references.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a Trust Center option?

Accepted Answer

A) Trusted App Catalogs 
B) Trusted Publishers 
C) Trusted Calculations 
D) Message Bar 
A) Trusted App Catalogs 
B) Trusted Publishers 
C) Trusted Calculations 
D) Message Bar

Question 10

Custom cell styles cannot be removed.

Accepted Answer

A) True 
 B)False

Question 11

Once lost,a password cannot be retrieved.

Accepted Answer

A) True 
 B)False

Question 12

________ can be placed in VBA to provide information regarding a macro.

Accepted Answer

The answer of ________ can be placed in VBA to...

Question 13

Macros are stored in ________.

Accepted Answer

The answer of Macros are stored in ________....

Question 14

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

Accepted Answer

A) Template 
B) Macros 
C) Themes 
D) Print settings 
A) Template 
B) Macros 
C) Themes 
D) Print settings

Question 15

Font attributes can be controlled with cell styles.

Accepted Answer

A) True 
 B)False

Question 16

The ________ function should be used to trap errors when creating templates.

Accepted Answer

The answer of The ________ function should be used to...

Question 17

Which of the following objects can be used to launch a macro?

Accepted Answer

A) Chart 
B) Function 
C) Image 
D) Hyperlink 
A) Chart 
B) Function 
C) Image 
D) Hyperlink

Question 18

A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.

Accepted Answer

The answer of A(n)________ is a collection of format settings...

Question 19

Excel passwords can be up to ________ characters.

Accepted Answer

The answer of Excel passwords can be up to ________...

Question 20

Which of the following cannot be modified in a custom cell style?

Accepted Answer

A) Number 
B) Alignment 
C) Print area 
D) Fill 
A) Number 
B) Alignment 
C) Print area 
D) Fill

Exam 43: Templates styles and Macros

Templates can be located and downloaded in the templates gallery.

Custom backgrounds can be applied to Excel worksheets.

Which function should be used to mask zero values in templates?

Which of the following formats is supported as a background in Excel?

What business practices should be used when creating a macro?

Which of the following is not a best practice when creating a macro?

Where are Trust Center options located?

By default,the macro recorder uses absolute references.

Which of the following is not a Trust Center option?

Custom cell styles cannot be removed.

Once lost,a password cannot be retrieved.

________ can be placed in VBA to provide information regarding a macro.

Macros are stored in ________.

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

Font attributes can be controlled with cell styles.

The ________ function should be used to trap errors when creating templates.

Which of the following objects can be used to launch a macro?

A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.

Excel passwords can be up to ________ characters.

Which of the following cannot be modified in a custom cell style?

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