Question 1

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

Accepted Answer

The Answer of Formats titles and headings and Provides the is...

Question 2

Which of the following is not a predefined cell style category?

Accepted Answer

A) Good, Bad and Neutral 
B) Titles and Headings 
C) Data and Model 
D) Analysis 
A) Good, Bad and Neutral 
B) Titles and Headings 
C) Data and Model 
D) Analysis D

Question 3

On which tab will you find the Protect Sheet command?

Accepted Answer

A) Insert 
B) Home 
C) Review 
D) Page Layout 
A) Insert 
B) Home 
C) Review 
D) Page Layout C

Question 4

If you forget your Excel password, you can recover it with your Microsoft account password.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is macro code embedded in a worksheet which does something malicious.

Accepted Answer

The answer of A(n)________ is macro code embedded in a...

Question 6

Excel has no method of stopping macro viruses.

Accepted Answer

A) True 
 B)False

Question 7

Protecting a workbook encrypts it for internet transmission.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ is a set of instructions that execute a sequence of commands to automate repetitive tasks.

Accepted Answer

The answer of A(n)________ is a set of instructions that...

Question 9

All cells are unlocked, by default.

Accepted Answer

A) True 
 B)False

Question 10

Where would you store macros that you'd like to use in any workbook?

Accepted Answer

A) A template 
B) The Normal Document 
C) The current workbook 
D) The Personal Macro Workbook 
A) A template 
B) The Normal Document 
C) The current workbook 
D) The Personal Macro Workbook

Question 11

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 12

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

Accepted Answer

The Answer of A collection of formats that include coordinating is...

Question 13

How would you use a relative cell reference in a macro?

Accepted Answer

A) Click Use Relative References before you perform the commands. 
B) Press F4 when selecting the range. 
C) You must edit the macro in the VBA editor to change the reference type. 
D) Hold the Shift key down while recording the macro. 
A) Click Use Relative References before you perform the commands. 
B) Press F4 when selecting the range. 
C) You must edit the macro in the VBA editor to change the reference type. 
D) Hold the Shift key down while recording the macro.

Question 14

Form Controls are on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 15

Excel templates are downloadable from the Template Gallery on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 16

On which tab is the Themes Gallery?

Accepted Answer

A) File 
B) Insert 
C) Page Layout 
D) View 
A) File 
B) Insert 
C) Page Layout 
D) View

Question 17

The Macro Recorder uses absolute references by default.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not a good guideline for creating a template?

Accepted Answer

A) Include instructions 
B) Enter all possible data. 
C) Use consistent and appropriate formatting 
D) Provide meaningful names to worksheets 
A) Include instructions 
B) Enter all possible data. 
C) Use consistent and appropriate formatting 
D) Provide meaningful names to worksheets

Question 19

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

Accepted Answer

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

Question 20

What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4, if your password is ExcelIsFun?

Accepted Answer

A) Sheet 2.Password:= "ExcelIsFun" 
B) Sheet 2.Unprotect Password:= "ExcelIsFun" 
C) Sheet 1.Protect Password:= "ExcelIsFun" 
D) Sheet 2.Unprotect Password:= ExcelIsFun 
A) Sheet 2.Password:= "ExcelIsFun" 
B) Sheet 2.Unprotect Password:= "ExcelIsFun" 
C) Sheet 1.Protect Password:= "ExcelIsFun" 
D) Sheet 2.Unprotect Password:= ExcelIsFun

Which of the following is not a predefined cell style category?

On which tab will you find the Protect Sheet command?

If you forget your Excel password, you can recover it with your Microsoft account password.

A(n)________ is macro code embedded in a worksheet which does something malicious.

Excel has no method of stopping macro viruses.

Protecting a workbook encrypts it for internet transmission.

A(n)________ is a set of instructions that execute a sequence of commands to automate repetitive tasks.

All cells are unlocked, by default.

Where would you store macros that you'd like to use in any workbook?

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

How would you use a relative cell reference in a macro?

Form Controls are on the Developer tab.

Excel templates are downloadable from the Template Gallery on the Insert tab.

On which tab is the Themes Gallery?

The Macro Recorder uses absolute references by default.

Which of the following is not a good guideline for creating a template?

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

What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4, if your password is ExcelIsFun?

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

Which of the following is not a predefined cell style category?

On which tab will you find the Protect Sheet command?

If you forget your Excel password, you can recover it with your Microsoft account password.

A(n)________ is macro code embedded in a worksheet which does something malicious.

Excel has no method of stopping macro viruses.

Protecting a workbook encrypts it for internet transmission.

A(n)________ is a set of instructions that execute a sequence of commands to automate repetitive tasks.

All cells are unlocked, by default.

Where would you store macros that you'd like to use in any workbook?

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

How would you use a relative cell reference in a macro?

Form Controls are on the Developer tab.

Excel templates are downloadable from the Template Gallery on the Insert tab.

On which tab is the Themes Gallery?

The Macro Recorder uses absolute references by default.

Which of the following is not a good guideline for creating a template?

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

What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4, if your password is ExcelIsFun?

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