Question 1

Privacy options can be edited in the ________.

Accepted Answer

Trust Center

Question 2

Where are custom cell styles saved?

Accepted Answer

A) The workbook in which you created the style 
B) A personal styles workbook 
C) My Documents 
D) A personal macro workbook 
A) The workbook in which you created the style 
B) A personal styles workbook 
C) My Documents 
D) A personal macro workbook A

Question 3

The maximum number of characters for a password is 255.

Accepted Answer

A) True 
 B)False  True

Question 4

What is the default file extension for a template?

Accepted Answer

A) .xls 
B) .xlsx 
C) .xltx
D.)xlm 
A) .xls 
B) .xlsx 
C) .xltx
D.)xlm

Question 5

Where are the default cell styles located?

Accepted Answer

A) Styles group 
B) Editing group 
C) Format group 
D) Cells group 
A) Styles group 
B) Editing group 
C) Format group 
D) Cells group

Question 6

Match between columns
                        Premises: Object
Macro Recorder
Visual Basic Editor
Module
Personal Macro Workbook

Accepted Answer

The Answer of A variable that contains both data and is...

Question 7

By default,the macro recorder uses ________ references.

Accepted Answer

The answer of By default,the macro recorder uses ________ references....

Question 8

Where are macros recorded with the macro recorder stored?

Accepted Answer

A) The current workbook 
B) The Templates folder 
C) The templates gallery 
D) My Documents 
A) The current workbook 
B) The Templates folder 
C) The templates gallery 
D) My Documents

Question 9

Once created a custom function cannot be edited.

Accepted Answer

A) True 
 B)False

Question 10

Data and Model,Titles and Headings,and Number Format are all examples of predefined ________.

Accepted Answer

The answer of Data and Model,Titles and Headings,and Number Format...

Question 11

Which of the following is true about a protected worksheet?

Accepted Answer

A) It cannot be saved 
B) It cannot be printed 
C) It cannot be edited 
D) It cannot be shared on SkyDrive 
A) It cannot be saved 
B) It cannot be printed 
C) It cannot be edited 
D) It cannot be shared on SkyDrive

Question 12

What is the default reference type when recording a macro?

Accepted Answer

A) Absolute 
B) Relative 
C) Mixed 
D) Normalitive 
A) Absolute 
B) Relative 
C) Mixed 
D) Normalitive

Question 13

What is the default save location for templates?

Accepted Answer

A) c :/Users\username\Documents\CustomOfficeTemplates 
B) c : /Users\MyDocuments 
C) c :/templates 
D) c :/Users	emplates 
A) c :/Users\username\Documents\CustomOfficeTemplates 
B) c : /Users\MyDocuments 
C) c :/templates 
D) c :/Users	emplates

Question 14

Which of the following is the file extension for a Personal Macro Workbook?

Accepted Answer

A) .xls 
B) .xlxs 
C) .xltm 
D) .xlsb 
A) .xls 
B) .xlxs 
C) .xltm 
D) .xlsb

Question 15

All templates should contain instructions.

Accepted Answer

A) True 
 B)False

Question 16

Macro security can be edited in the ________.

Accepted Answer

The answer of Macro security can be edited in the...

Question 17

Once applied custom backgrounds cannot be deleted.

Accepted Answer

A) True 
 B)False

Question 18

Where can a macro be deleted?

Accepted Answer

A) Backstage 
B) Macro dialog box 
C) Developer tab 
D) Insert tab 
A) Backstage 
B) Macro dialog box 
C) Developer tab 
D) Insert tab

Question 19

Locked cells cannot be ________.

Accepted Answer

The answer of Locked cells cannot be ________....

Question 20

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

Accepted Answer

The answer of The file extension for an Excel Macro-Enabled...

Exam 43: Templates styles and Macros

Privacy options can be edited in the ________.

Where are custom cell styles saved?

The maximum number of characters for a password is 255.

What is the default file extension for a template?

Where are the default cell styles located?

By default,the macro recorder uses ________ references.

Where are macros recorded with the macro recorder stored?

Once created a custom function cannot be edited.

Data and Model,Titles and Headings,and Number Format are all examples of predefined ________.

Which of the following is true about a protected worksheet?

What is the default reference type when recording a macro?

What is the default save location for templates?

Which of the following is the file extension for a Personal Macro Workbook?

All templates should contain instructions.

Macro security can be edited in the ________.

Once applied custom backgrounds cannot be deleted.

Where can a macro be deleted?

Locked cells cannot be ________.

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

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters