Question 1

View and edit macros in the ________.

Accepted Answer

VBA editor

Question 2

Which of the following are not included in themes?

Accepted Answer

A) Fonts 
B) Colors 
C) Formulas 
D) Effects 
A) Fonts 
B) Colors 
C) Formulas 
D) Effects

Question 3

A Background in a Worksheet looks like a ________.

Accepted Answer

A) graphic inserted in the top left corner 
B) webpage with a graphic behind the data 
C) graphic instead of the data on the worksheet 
D) graphic display on top of the data 
A) graphic inserted in the top left corner 
B) webpage with a graphic behind the data 
C) graphic instead of the data on the worksheet 
D) graphic display on top of the data

Question 4

By default, ________ are locked.

Accepted Answer

The answer of By default, ________ are locked....

Question 5

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

Accepted Answer

A) New font 
B) Change 
C) Styles 
D) Modify 
A) New font 
B) Change 
C) Styles 
D) Modify

Question 6

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

Accepted Answer

A) Cell references 
B) Functions 
C) Styles 
D) Text 
A) Cell references 
B) Functions 
C) Styles 
D) Text

Question 7

________ is the file extension for Macro-Enabled Workbooks.

Accepted Answer

The answer of ________ is the file extension for Macro-Enabled...

Question 8

Match between columns
                        Premises: Module
Keyword
Object
Sub Procedure
Comment

Accepted Answer

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

Question 9

Cells can be locked from the ________ group on the Home tab.

Accepted Answer

The answer of Cells can be locked from the ________...

Question 10

Custom Functions are recorded in the macro recorder.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ is one that prevents users from editing the contents or formatting.

Accepted Answer

The answer of A(n)________ is one that prevents users from...

Question 12

Which of the following items is not stored inside VBA modules?

Accepted Answer

A) Sub procedures 
B) Keywords 
C) Index documents 
D) Comments 
A) Sub procedures 
B) Keywords 
C) Index documents 
D) Comments

Question 13

Trusted locations are websites where you download templates.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

________ files save with .xltx file extensions.

Accepted Answer

The answer of ________ files save with .xltx file extensions....

Question 16

PDF file format is XML Paper Specifications.

Accepted Answer

A) True 
 B)False

Question 17

Where do you edit a macro?

Accepted Answer

A) Macro editor 
B) Macros must be created from scratch. 
C) VBA Editor 
D) Notepad 
A) Macro editor 
B) Macros must be created from scratch. 
C) VBA Editor 
D) Notepad

Question 18

Which of the following is false about a VBA object?

Accepted Answer

A) Contains data 
B) Contains code 
C) Starts with ' 
D) Represents a Range 
A) Contains data 
B) Contains code 
C) Starts with ' 
D) Represents a Range

Question 19

A cell style is a collection of ________.

Accepted Answer

A) themes 
B) format settings 
C) fonts 
D) colors 
A) themes 
B) format settings 
C) fonts 
D) colors

Question 20

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

Accepted Answer

The answer of Data and Model, Titles and Headings, and...

View and edit macros in the ________.

Which of the following are not included in themes?

A Background in a Worksheet looks like a ________.

By default, ________ are locked.

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

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

________ is the file extension for Macro-Enabled Workbooks.

Cells can be locked from the ________ group on the Home tab.

Custom Functions are recorded in the macro recorder.

A(n)________ is one that prevents users from editing the contents or formatting.

Which of the following items is not stored inside VBA modules?

Trusted locations are websites where you download templates.

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

________ files save with .xltx file extensions.

PDF file format is XML Paper Specifications.

Where do you edit a macro?

Which of the following is false about a VBA object?

A cell style is a collection of ________.

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 12: Templates, Styles, and Macros

View and edit macros in the ________.

Which of the following are not included in themes?

A Background in a Worksheet looks like a ________.

By default, ________ are locked.

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

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

________ is the file extension for Macro-Enabled Workbooks.

Cells can be locked from the ________ group on the Home tab.

Custom Functions are recorded in the macro recorder.

A(n)________ is one that prevents users from editing the contents or formatting.

Which of the following items is not stored inside VBA modules?

Trusted locations are websites where you download templates.

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

________ files save with .xltx file extensions.

PDF file format is XML Paper Specifications.

Where do you edit a macro?

Which of the following is false about a VBA object?

A cell style is a collection of ________.

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters