Question 1

PDF file format is XML Paper Specifications.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is false about a VBA object?

Accepted Answer

A) Contains data 
B) Contains code 
C) Starts with ' 
D) Represents a Range 
A) Contains data 
B) Contains code 
C) Starts with ' 
D) Represents a Range

Question 3

The background of an Excel Worksheet is always white.

Accepted Answer

A) True 
 B)False

Question 4

Macro Buttons in worksheets are ________ buttons available on the Developer tab.

Accepted Answer

The answer of Macro Buttons in worksheets are ________ buttons...

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 templates are downloadable from the Template Gallery on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 7

To make a comment line in VBA,start the line with ________.

Accepted Answer

',single q

Question 8

All cells are unlocked,by default.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Where do you edit a macro?

Accepted Answer

A) Macro editor 
B) Macros must be created from scratch. 
C) VBA Editor 
D) Notepad 
A) Macro editor 
B) Macros must be created from scratch. 
C) VBA Editor 
D) Notepad

Question 11

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 12

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 13

It is helpful to provide instructions in a template.

Accepted Answer

A) True 
 B)False

Question 14

Images or other objects can serve as buttons to run macros.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Sub Procedure
Object
Comment
Keyword
Module

Accepted Answer

The Answer of Starts with an apostrophe and green font.Used is...

Question 16

Form Controls are on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is false about recording a macro?

Accepted Answer

A) Cell selections can be recorded as absolute references. 
B) There is a pause button which allows you to remove mistakes as you record. 
C) The recorder records everything you do. 
D) It is a good idea to plan your steps and practice them before recording. 
A) Cell selections can be recorded as absolute references. 
B) There is a pause button which allows you to remove mistakes as you record. 
C) The recorder records everything you do. 
D) It is a good idea to plan your steps and practice them before recording.

Question 18

What do Miles and Rate represent in the following line of code?
Function Mileage (Miles,Rate)

Accepted Answer

A) Comments 
B) Function arguments. 
C) Sub procedures 
D) Keywords 
A) Comments 
B) Function arguments. 
C) Sub procedures 
D) Keywords

Question 19

Cells can be locked from the ________ group on the Home tab.

Accepted Answer

The answer of Cells can be locked from the ________...

Question 20

A cell style is a collection of ________.

Accepted Answer

A) themes 
B) format settings 
C) fonts 
D) colors 
A) themes 
B) format settings 
C) fonts 
D) colors

PDF file format is XML Paper Specifications.

Which of the following is false about a VBA object?

The background of an Excel Worksheet is always white.

Macro Buttons in worksheets are ________ buttons available on the Developer tab.

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

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

To make a comment line in VBA,start the line with ________.

All cells are unlocked,by default.

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

Where do you edit a macro?

What file extension do templates use?

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

It is helpful to provide instructions in a template.

Images or other objects can serve as buttons to run macros.

Form Controls are on the Developer tab.

Which of the following is false about recording a macro?

What do Miles and Rate represent in the following line of code? Function Mileage (Miles,Rate)

Cells can be locked from the ________ group on the Home tab.

A cell style is a collection of ________.

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

PDF file format is XML Paper Specifications.

Which of the following is false about a VBA object?

The background of an Excel Worksheet is always white.

Macro Buttons in worksheets are ________ buttons available on the Developer tab.

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

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

To make a comment line in VBA,start the line with ________.

All cells are unlocked,by default.

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

Where do you edit a macro?

What file extension do templates use?

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

It is helpful to provide instructions in a template.

Images or other objects can serve as buttons to run macros.

Form Controls are on the Developer tab.

Which of the following is false about recording a macro?

What do Miles and Rate represent in the following line of code? Function Mileage (Miles,Rate)

Cells can be locked from the ________ group on the Home tab.

A cell style is a collection of ________.

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