Question 1

By default the ________ uses absolute cell references when storing a macro.

Accepted Answer

The answer of By default the ________ uses absolute cell...

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

There are many templates available online.

Accepted Answer

A) True 
 B)False

Question 4

Theme fonts may not be altered.

Accepted Answer

A) True 
 B)False

Question 5

________ files save with .xltx file extensions.

Accepted Answer

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

Question 6

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 7

The Macro Recorder uses absolute references by default.

Accepted Answer

A) True 
 B)False

Question 8

Where would you find the Template Gallery?

Accepted Answer

A) Insert tab 
B) Page Layout tab 
C) View tab 
D) Backstage view 
A) Insert tab 
B) Page Layout tab 
C) View tab 
D) Backstage view

Question 9

Formatting is limited in Templates.

Accepted Answer

A) True 
 B)False

Question 10

By default,________ are locked.

Accepted Answer

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

Question 11

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 12

How do you insert a button to run a macro in a worksheet?

Accepted Answer

A) Add a Form Control button that runs the macro 
B) Use the Button Builder on the Code group 
C) The button has to be inserted on the Quick Access Toolbar. 
D) You must use VBA code to do this. 
A) Add a Form Control button that runs the macro 
B) Use the Button Builder on the Code group 
C) The button has to be inserted on the Quick Access Toolbar. 
D) You must use VBA code to do this.

Question 13

A user can modify a cell style.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

Protected workbooks cannot be ________.

Accepted Answer

A) saved 
B) printed 
C) shared 
D) edited 
A) saved 
B) printed 
C) shared 
D) edited

Question 16

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 17

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 18

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 19

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 20

If you want to place Confidential behind the data in a worksheet,you use a custom ________.

Accepted Answer

The answer of If you want to place Confidential behind...

By default the ________ uses absolute cell references when storing a macro.

Which of the following are not included in themes?

There are many templates available online.

Theme fonts may not be altered.

________ files save with .xltx file extensions.

Where are custom cell styles stored?

The Macro Recorder uses absolute references by default.

Where would you find the Template Gallery?

Formatting is limited in Templates.

By default,________ are locked.

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

How do you insert a button to run a macro in a worksheet?

A user can modify a cell style.

What function traps errors in a custom template?

Protected workbooks cannot be ________.

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

Where can you delete or run a macro?

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

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

If you want to place Confidential behind the data in a worksheet,you use a custom ________.

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

By default the ________ uses absolute cell references when storing a macro.

Which of the following are not included in themes?

There are many templates available online.

Theme fonts may not be altered.

________ files save with .xltx file extensions.

Where are custom cell styles stored?

The Macro Recorder uses absolute references by default.

Where would you find the Template Gallery?

Formatting is limited in Templates.

By default,________ are locked.

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

How do you insert a button to run a macro in a worksheet?

A user can modify a cell style.

What function traps errors in a custom template?

Protected workbooks cannot be ________.

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

Where can you delete or run a macro?

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

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

If you want to place Confidential behind the data in a worksheet,you use a custom ________.

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