Question 1

Where is the New Cell Style command?

Accepted Answer

A) On the Styles Gallery 
B) On the Themes gallery 
C) On the Page Layout tab 
D) On the Insert tab 
A) On the Styles Gallery 
B) On the Themes gallery 
C) On the Page Layout tab 
D) On the Insert tab A

Question 2

Select ________ in Backstage view to access the Template Gallery.

Accepted Answer

New

Question 3

Keywords are words or symbols that are reserved for specific actions in VBA.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

Trusted locations are websites where you download templates.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

Themes alter formulas.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Question 10

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 11

The cell styles gallery is on the ________ tab.

Accepted Answer

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

Question 12

The Themes Gallery is located on the ________ tab.

Accepted Answer

The answer of The Themes Gallery is located on the...

Question 13

Cell Styles are on the Page Layout tab.

Accepted Answer

A) True 
 B)False

Question 14

A forgotten ________ in Excel is unrecoverable.

Accepted Answer

The answer of A forgotten ________ in Excel is unrecoverable....

Question 15

The IFERROR function traps errors in Excel templates.

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ is a container in which VBA code is stored.

Accepted Answer

The answer of A(n)________ is a container in which VBA...

Question 17

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

Accepted Answer

The Answer of Automation for a series of repetitive tasks is...

Question 18

Which of the following is a partially completed workbook to be used as a model for a fully completed document?

Accepted Answer

A) Theme 
B) Sub Procedure 
C) Macro 
D) Template 
A) Theme 
B) Sub Procedure 
C) Macro 
D) Template

Question 19

Functions are edited in the ________.

Accepted Answer

VBA editor

Question 20

Good,Bad,and Neutral are predefined cell styles.

Accepted Answer

A) True 
 B)False

Where is the New Cell Style command?

Select ________ in Backstage view to access the Template Gallery.

Keywords are words or symbols that are reserved for specific actions in VBA.

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

Trusted locations are websites where you download templates.

On which tab will you find the Protect Sheet command?

Themes alter formulas.

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

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

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

The cell styles gallery is on the ________ tab.

The Themes Gallery is located on the ________ tab.

Cell Styles are on the Page Layout tab.

A forgotten ________ in Excel is unrecoverable.

The IFERROR function traps errors in Excel templates.

A(n)________ is a container in which VBA code is stored.

Which of the following is a partially completed workbook to be used as a model for a fully completed document?

Functions are edited in the ________.

Good,Bad,and Neutral are predefined cell styles.

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

Where is the New Cell Style command?

Select ________ in Backstage view to access the Template Gallery.

Keywords are words or symbols that are reserved for specific actions in VBA.

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

Trusted locations are websites where you download templates.

On which tab will you find the Protect Sheet command?

Themes alter formulas.

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

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

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

The cell styles gallery is on the ________ tab.

The Themes Gallery is located on the ________ tab.

Cell Styles are on the Page Layout tab.

A forgotten ________ in Excel is unrecoverable.

The IFERROR function traps errors in Excel templates.

A(n)________ is a container in which VBA code is stored.

Which of the following is a partially completed workbook to be used as a model for a fully completed document?

Functions are edited in the ________.

Good,Bad,and Neutral are predefined cell styles.

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