Match between columns Premises: .xlsm .xltm .xlsb .xlsx .xls

The Answer of Excel Macro-Enabled Workbook and Default Excel workbook is...

Exam 29: Excel: Templates, styles, and Macros

Macros are stored in modules.

(True/False)

5.0/5

(31)

Question 61

When creating templates,IFERROR should be used to mask zero values.

(True/False)

4.8/5

(32)

Question 62

Where are custom cell styles saved?

(Multiple Choice)

4.7/5

(39)

Question 63

A user can create custom cell styles.

(True/False)

4.8/5

(41)

Question 64

Good,Bad,and Neutral are predefined cell styles.

(True/False)

4.8/5

(40)

Question 65

Match the following terms to the corresponding description:

Personal macro workbook

The default reference option when using the macro recorder

Form control button

Contains the Form Controls tools

Trust Center

Stores macros that can be accessed by any Excel workbook

Correct Answer:

Verified

Personal macro workbook

Form control button

Trust Center

Developer tab

Absolute reference

(Matching)

5.0/5

(34)

Question 66

Match the following Trust Center options with the correct description:

Trusted Publishers

Enables you to trust network documents to open without Excel displaying any security warnings

Add-Ins

Directs Excel to trust digitally signed workbooks by certain creators

Trusted Documents

Enables you to specify which add-ins will be allowed to run given the desired level of security

Correct Answer:

Verified

Trusted Publishers

Add-Ins

Trusted Documents

Privacy Options

File Block Settings

(Matching)

5.0/5

(41)

Question 67

Once lost,a password cannot be retrieved.

(True/False)

4.9/5

(36)

Question 68

Once applied custom backgrounds cannot be deleted.

(True/False)

4.7/5

(38)

Question 69

Custom styles cannot be applied to other workbooks.

(True/False)

4.8/5

(37)

Question 70

Which of the following is not a Trust Center option?

(Multiple Choice)

4.9/5

(26)

Question 71

Macro security can be edited in the ________.

(Short Answer)

4.8/5

(32)

Question 72

Macros can be edited in the ________.

(Short Answer)

4.7/5

(32)

Question 73

Match the following terms with the corresponding descriptions:

.xlsm

Excel Macro-Enabled Workbook

.xltm

Default Excel workbook format

.xlsb

Excel Macro-Enabled Template

Correct Answer:

Verified

.xlsm

.xltm

.xlsb

.xlsx

.xls

(Matching)

4.9/5

(30)

Question 74

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

(Multiple Choice)

4.9/5

(47)

Question 75

Comments cannot be viewed in the VBA editor.

(True/False)

4.8/5

(36)

Question 76

Macros are stored in ________.

(Short Answer)

4.8/5

(41)

Question 77

Where is the Themes gallery located?

(Multiple Choice)

4.9/5

(38)

Question 78

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

(Short Answer)

4.8/5

(37)

Question 79

By default all cells are locked.

(True/False)

4.9/5

(33)

Question 80

Exam 29: Excel: Templates, styles, and Macros

Macros are stored in modules.

When creating templates,IFERROR should be used to mask zero values.

Where are custom cell styles saved?

A user can create custom cell styles.

Good,Bad,and Neutral are predefined cell styles.

Once lost,a password cannot be retrieved.

Once applied custom backgrounds cannot be deleted.

Custom styles cannot be applied to other workbooks.

Which of the following is not a Trust Center option?

Macro security can be edited in the ________.

Macros can be edited in the ________.

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

Comments cannot be viewed in the VBA editor.

Macros are stored in ________.

Where is the Themes gallery located?

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

By default all cells are locked.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters