Question 1

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 2

Form controls are located on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following tools is best suited to complete repetitive tasks in Excel?

Accepted Answer

A) Macros 
B) Templates 
C) Styles 
D) Themes 
A) Macros 
B) Templates 
C) Styles 
D) Themes

Question 4

Excel passwords can be up to ________ characters.

Accepted Answer

The answer of Excel passwords can be up to ________...

Question 5

What business practices should be used when creating a macro?

Accepted Answer

When creating a macro using the Macro Re

Question 6

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Accepted Answer

A) Themes 
B) Custom functions 
C) Backgrounds 
D) Styles 
A) Themes 
B) Custom functions 
C) Backgrounds 
D) Styles

Question 7

Which of the following tabs contains Form Controls?

Accepted Answer

A) Insert 
B) Data 
C) Developer 
D) Formulas 
A) Insert 
B) Data 
C) Developer 
D) Formulas

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

Privacy options can be edited in the ________.

Accepted Answer

The answer of Privacy options can be edited in the...

Question 10

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 11

Templates can be located and downloaded in the templates gallery.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Cell style
Template
Template gallery
Background
Theme

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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 15

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

Accepted Answer

The Answer of Use to format titles and headings,such as is...

Question 16

________ can be placed in VBA to provide information regarding a macro.

Accepted Answer

The answer of ________ can be placed in VBA to...

Question 17

The macro recorder can append a previously recorded macro.

Accepted Answer

A) True 
 B)False

Question 18

By default all cells in a workbook are ________.

Accepted Answer

The answer of By default all cells in a workbook...

Question 19

The VBA editor can be access using the keystroke combination ________.

Accepted Answer

The answer of The VBA editor can be access using...

Question 20

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

Exam 29: Excel: Templates, styles, and Macros

Where is the Template gallery located?

Form controls are located on the Developer tab.

Which of the following tools is best suited to complete repetitive tasks in Excel?

Excel passwords can be up to ________ characters.

What business practices should be used when creating a macro?

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Which of the following tabs contains Form Controls?

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

Privacy options can be edited in the ________.

Where are macros recorded with the macro recorder stored?

Templates can be located and downloaded in the templates gallery.

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

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

________ can be placed in VBA to provide information regarding a macro.

The macro recorder can append a previously recorded macro.

By default all cells in a workbook are ________.

The VBA editor can be access using the keystroke combination ________.

Which of the following formats does not support macros?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters