Question 1

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

Accepted Answer

A) Data and Model 
B) Number Format 
C) Titles and Headings 
D) Analysis 
A) Data and Model 
B) Number Format 
C) Titles and Headings 
D) Analysis

Question 2

A ________ is a collection of formats that include coordinating colors,fonts,and special effects to provide a stylish appearance.

Accepted Answer

The answer of A ________ is a collection of formats...

Question 3

Match between columns
                        Premises: Privacy Options
Trusted Documents
Trusted Publishers
Add-Ins
File Block Settings

Accepted Answer

The Answer of Enables you to select which types of is...

Question 4

What is the default folder for Personal Macro Workbooks in Windows 8?

Accepted Answer

A) c : /Users\Username\documents 
B) c : /Users\Username\AppData\Roaming\Microsoft\Excel\XLStart 
C) c : /Users\Username\AppData\Roaming\XLStart 
D) c :/Users\Username\Excel 
A) c : /Users\Username\documents 
B) c : /Users\Username\AppData\Roaming\Microsoft\Excel\XLStart 
C) c : /Users\Username\AppData\Roaming\XLStart 
D) c :/Users\Username\Excel

Question 5

Custom styles cannot be applied to other workbooks.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The Answer of Provide the same formatting as commands in is...

Question 7

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

Accepted Answer

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

Question 8

Which of the following is not prevented when a worksheet is protected?

Accepted Answer

A) Inserting 
B) Printing 
C) Deleting 
D) Copying 
A) Inserting 
B) Printing 
C) Deleting 
D) Copying

Question 9

When creating templates,IFERROR should be used to mask zero values.

Accepted Answer

A) True 
 B)False

Question 10

Macros can be edited in the ________.

Accepted Answer

The answer of Macros can be edited in the ________....

Question 11

Custom cell styles are stored in the ________ workbook.

Accepted Answer

The answer of Custom cell styles are stored in the...

Question 12

A user can create custom cell styles.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a method for creating macros?

Accepted Answer

A) Macro recorder 
B) Formula builder 
C) Insert function button 
D) Developer tools 
A) Macro recorder 
B) Formula builder 
C) Insert function button 
D) Developer tools

Question 14

Where is the Template gallery located?

Accepted Answer

A) Insert tab 
B) Backstage 
C) Data tab 
D) Formulas tab 
A) Insert tab 
B) Backstage 
C) Data tab 
D) Formulas tab

Question 15

Which of the following is not a good practice when creating a template?

Accepted Answer

A) Using descriptive labels 
B) Using cell references in formulas 
C) Locking view settings 
D) Including instructions 
A) Using descriptive labels 
B) Using cell references in formulas 
C) Locking view settings 
D) Including instructions

Question 16

Match the following terms to the corresponding description:
I.Absolute reference
II.Form control button
III.Developer tab
IV.Trust Center
V.Personal macro workbook

Accepted Answer

A) Stores macros that can be accessed by any Excel workbook 
B) Contains security options for Microsoft Excel 
C) An object that can have added functionality when partnered with a macro 
D) The default reference option when using the macro recorder 
E) Contains the Form Controls tools 
A) Stores macros that can be accessed by any Excel workbook 
B) Contains security options for Microsoft Excel 
C) An object that can have added functionality when partnered with a macro 
D) The default reference option when using the macro recorder 
E) Contains the Form Controls tools

Question 17

A ________ is a set of instructions that execute a sequence of commands to automate repetitive or routine tasks.

Accepted Answer

The answer of A ________ is a set of instructions...

Question 18

Good,Bad,and Neutral are predefined cell styles.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following formats does not support macros?

Accepted Answer

A) .xlsm 
B) .xlsb 
C) .)xltm 
D) .xlsx 
A) .xlsm 
B) .xlsb 
C) .)xltm 
D) .xlsx

Question 20

Match between columns
                        Premises: .xlsx
.xlsm
.xls
.xlsb
.xltm

Accepted Answer

The Answer of Excel Macro-Enabled Workbook and Excel Binary Workbook is...

Exam 43: Templates styles and Macros

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

A ________ is a collection of formats that include coordinating colors,fonts,and special effects to provide a stylish appearance.

What is the default folder for Personal Macro Workbooks in Windows 8?

Custom styles cannot be applied to other workbooks.

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

Which of the following is not prevented when a worksheet is protected?

When creating templates,IFERROR should be used to mask zero values.

Macros can be edited in the ________.

Custom cell styles are stored in the ________ workbook.

A user can create custom cell styles.

Which of the following is a method for creating macros?

Where is the Template gallery located?

Which of the following is not a good practice when creating a template?

Match the following terms to the corresponding description: I.Absolute reference II.Form control button III.Developer tab IV.Trust Center V.Personal macro workbook

A ________ is a set of instructions that execute a sequence of commands to automate repetitive or routine tasks.

Good,Bad,and Neutral are predefined cell styles.

Which of the following formats does not support macros?

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