Question 1

On which tab is the insert background feature located?

Accepted Answer

A) Page Layout 
B) Formulas 
C) Data 
D) Home 
A) Page Layout 
B) Formulas 
C) Data 
D) Home

Question 2

Use the ________ function to trap errors when creating templates.

Accepted Answer

The answer of Use the ________ function to trap errors...

Question 3

Where do you find the Trust Center?

Accepted Answer

A) Developer tab 
B) Excel Options 
C) Insert tab 
D) View tab 
A) Developer tab 
B) Excel Options 
C) Insert tab 
D) View tab

Question 4

What color are comments in VBA?

Accepted Answer

A) Black 
B) Green 
C) Red 
D) Blue 
A) Black 
B) Green 
C) Red 
D) Blue

Question 5

Match between columns
                        Premises: Number Format
Good,Bad,and Neutral
Data and Model
Themed Cell Styles
Titles and Headings

Accepted Answer

The Answer of Emphasizes bad,good,or neutral results and Provides visual is...

Question 6

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 7

Match between columns
                        Premises: Template
Template Gallery
Theme
Theme Gallery
Cell Style

Accepted Answer

The Answer of A partially completed document to use as is...

Question 8

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

Accepted Answer

The Answer of Up to 255 characters to unlock a is...

Question 9

A(n)________ 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(n)________ is a partially completed document that...

Question 10

A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.

Accepted Answer

The answer of A(n)________ performs actions on a workbook but...

Question 11

Which of the following is not an option in the Trust Center?

Accepted Answer

A) Trusted Publishers 
B) Trusted Locations 
C) Trusted App Catalogs 
D) Trusted Websites 
A) Trusted Publishers 
B) Trusted Locations 
C) Trusted App Catalogs 
D) Trusted Websites

Question 12

View and edit macros in the ________.

Accepted Answer

VBA editor

Question 13

Excel has no method of stopping macro viruses.

Accepted Answer

A) True 
 B)False

Question 14

Start a custom function in a new ________.

Accepted Answer

The answer of Start a custom function in a new...

Question 15

The file extension for an Excel Macro-Enabled Workbook is .xltm.

Accepted Answer

A) True 
 B)False

Question 16

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 17

What does the following line of code do to the selected cell?
Selection.Font.Bold = False

Accepted Answer

A) Turns on bold formatting in the selected cell. 
B) Replaces the contents of the selected cell with "False" 
C) Turns off bold formatting in the selected cell. 
D) Nothing,it contains a syntax error. 
A) Turns on bold formatting in the selected cell. 
B) Replaces the contents of the selected cell with "False" 
C) Turns off bold formatting in the selected cell. 
D) Nothing,it contains a syntax error.

On which tab is the insert background feature located?

Use the ________ function to trap errors when creating templates.

Where do you find the Trust Center?

What color are comments in VBA?

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

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

A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.

Which of the following is not an option in the Trust Center?

View and edit macros in the ________.

Excel has no method of stopping macro viruses.

Start a custom function in a new ________.

The file extension for an Excel Macro-Enabled Workbook is .xltm.

A Background in a Worksheet looks like a ________.

What does the following line of code do to the selected cell? Selection.Font.Bold = False

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Office 2016 Common Features

Filters

Exam 12: Templates, styles, and Macros

On which tab is the insert background feature located?

Use the ________ function to trap errors when creating templates.

Where do you find the Trust Center?

What color are comments in VBA?

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

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

A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.

Which of the following is not an option in the Trust Center?

View and edit macros in the ________.

Excel has no method of stopping macro viruses.

Start a custom function in a new ________.

The file extension for an Excel Macro-Enabled Workbook is .xltm.

A Background in a Worksheet looks like a ________.

What does the following line of code do to the selected cell? Selection.Font.Bold = False

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Office 2016 Common Features

Filters