Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Theme fonts may not be altered.

Accepted Answer

A) True 
 B)False

Question 3

What file extension do templates use?

Accepted Answer

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

Question 4

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 5

What would be the first line of the module for a function named Mileage with parameters Miles and Rate?

Accepted Answer

A) Function Mileage (Miles, Rate) 
B) Sub Mileage (Miles, Rate) 
C) Mileage (Miles, Rate) 
D) End Function 
A) Function Mileage (Miles, Rate) 
B) Sub Mileage (Miles, Rate) 
C) Mileage (Miles, Rate) 
D) End Function

Question 6

What is the file extension for a Macro-Enabled Workbook?

Accepted Answer

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

Question 7

A password on a protected workbook can be ________ characters long.

Accepted Answer

The answer of A password on a protected workbook can...

Question 8

In VBA, everything between and including the two following lines would be the CleanData sub procedure.
Sub CleanData()
End Sub

Accepted Answer

A) True 
 B)False

Question 9

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.

Question 10

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 11

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 12

Where are custom cell styles stored?

Accepted Answer

A) Template gallery 
B) Themes gallery 
C) Current workbook 
D) They are not stored. 
A) Template gallery 
B) Themes gallery 
C) Current workbook 
D) They are not stored.

Question 13

How many characters can an Excel password have?

Accepted Answer

A) 12 
B) 48 
C) 156 
D) 255 
A) 12 
B) 48 
C) 156 
D) 255

Question 14

Excel templates use the .xlsx file extension.

Accepted Answer

A) True 
 B)False

Question 15

Where can you delete or run a macro?

Accepted Answer

A) VBA Editor 
B) Macro dialog box 
C) Insert tab 
D) Backstage view 
A) VBA Editor 
B) Macro dialog box 
C) Insert tab 
D) Backstage view

Question 16

Formatting is limited in Templates.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Personal Macro Workbook
VBA Editor
Absolute Reference
Macro
Macro Recorder

Accepted Answer

The Answer of Default cell reference type in macros and is...

Question 18

Select ________ in Backstage view to access the Template Gallery.

Accepted Answer

The answer of Select ________ in Backstage view to access...

Question 19

In Windows 10, Workbook templates save in this location by default.

Accepted Answer

A) C : \Users\username\Documents\Temp 
B) C : \Users\username\Documents\Templates 
C) C : \Users\username\Documents\Documents\Custom Office Templates 
D) C : \Users\username\Documents\Custom 
A) C : \Users\username\Documents\Temp 
B) C : \Users\username\Documents\Templates 
C) C : \Users\username\Documents\Documents\Custom Office Templates 
D) C : \Users\username\Documents\Custom

Question 20

What function traps errors in a custom template?

Accepted Answer

A) ERRORTRAP 
B) IF(#ErrorValue) 
C) IFERROR 
D) FINDERROR 
A) ERRORTRAP 
B) IF(#ErrorValue) 
C) IFERROR 
D) FINDERROR

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

Theme fonts may not be altered.

What file extension do templates use?

Where do you find the Trust Center?

What would be the first line of the module for a function named Mileage with parameters Miles and Rate?

What is the file extension for a Macro-Enabled Workbook?

A password on a protected workbook can be ________ characters long.

In VBA, everything between and including the two following lines would be the CleanData sub procedure. Sub CleanData() End Sub

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

On which tab is the insert background feature located?

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

Where are custom cell styles stored?

How many characters can an Excel password have?

Excel templates use the .xlsx file extension.

Where can you delete or run a macro?

Formatting is limited in Templates.

Select ________ in Backstage view to access the Template Gallery.

In Windows 10, Workbook templates save in this location by default.

What function traps errors in a custom template?

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

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

Theme fonts may not be altered.

What file extension do templates use?

Where do you find the Trust Center?

What would be the first line of the module for a function named Mileage with parameters Miles and Rate?

What is the file extension for a Macro-Enabled Workbook?

A password on a protected workbook can be ________ characters long.

In VBA, everything between and including the two following lines would be the CleanData sub procedure. Sub CleanData() End Sub

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

On which tab is the insert background feature located?

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

Where are custom cell styles stored?

How many characters can an Excel password have?

Excel templates use the .xlsx file extension.

Where can you delete or run a macro?

Formatting is limited in Templates.

Select ________ in Backstage view to access the Template Gallery.

In Windows 10, Workbook templates save in this location by default.

What function traps errors in a custom template?

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