Question 1

New templates can be located and viewed in the ________.

Accepted Answer

Template gallery

Question 2

Match between columns
                        Premises: Visual Basic for Applications
Module
Sub procedure
Custom function
Macro Recorder

Accepted Answer

The Answer of A robust programming language that is the is...

Question 3

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

Accepted Answer

A) Template 
B) Macros 
C) Themes 
D) Print settings 
A) Template 
B) Macros 
C) Themes 
D) Print settings D

Question 4

Which of the following is not an Office theme?

Accepted Answer

A) Office 
B) Integral 
C) Helvetica 
D) Frame 
A) Office 
B) Integral 
C) Helvetica 
D) Frame

Question 5

Where is the Protect Sheet command located in the Ribbon?

Accepted Answer

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

Question 6

Where is the Insert Background feature located?

Accepted Answer

A) Backstage 
B) Page Layout tab 
C) Formulas tab 
D) Insert tab 
A) Backstage 
B) Page Layout tab 
C) Formulas tab 
D) Insert tab

Question 7

Recorded macros can be viewed in the ________.

Accepted Answer

The answer of Recorded macros can be viewed in the...

Question 8

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 9

A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.

Accepted Answer

The answer of A(n)________ is a collection of format settings...

Question 10

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 11

Which of the following are used in VBA to leave notes or instructions regarding the macro?

Accepted Answer

A) Comments 
B) Keywords 
C) Indicators 
D) Index notes 
A) Comments 
B) Keywords 
C) Indicators 
D) Index notes

Question 12

A ________ is a partially completed document that you use as a model to create other documents
that have the same structure and purpose.

Accepted Answer

The answer of A ________ is a partially completed document...

Question 13

.xlsb files do not support macros.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Comments in VBA appear in what color?

Accepted Answer

A) Red 
B) Green 
C) Blue 
D) Black 
A) Red 
B) Green 
C) Blue 
D) Black

Question 16

Custom backgrounds can be applied to Excel worksheets.

Accepted Answer

A) True 
 B)False

Question 17

By default,the Developer tab is ________.

Accepted Answer

The answer of By default,the Developer tab is ________....

Question 18

Match between columns
                        Premises: Module
Sub procedure
Keyword
Comment
Visual Basic for Applications

Accepted Answer

The Answer of A robust programming language that is the is...

Question 19

Which of the following is not true about locked cells?

Accepted Answer

A) Locked cells can be edited 
B) All cells are locked by default 
C) A password is required to unlock the cells 
D) A locked cell is indicated by a padlock icon in the Format menu 
A) Locked cells can be edited 
B) All cells are locked by default 
C) A password is required to unlock the cells 
D) A locked cell is indicated by a padlock icon in the Format menu

Question 20

Which of the following is not controlled with cell style formats?

Accepted Answer

A) Font attributes 
B) Print settings 
C) Cell-protection settings 
D) Border and fill styles 
A) Font attributes 
B) Print settings 
C) Cell-protection settings 
D) Border and fill styles

Exam 29: Excel: Templates, styles, and Macros

New templates can be located and viewed in the ________.

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

Which of the following is not an Office theme?

Where is the Protect Sheet command located in the Ribbon?

Where is the Insert Background feature located?

Recorded macros can be viewed in the ________.

Where are the default cell styles located?

A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.

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

Which of the following are used in VBA to leave notes or instructions regarding the macro?

A ________ is a partially completed document that you use as a model to create other documents that have the same structure and purpose.

.xlsb files do not support macros.

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

Comments in VBA appear in what color?

Custom backgrounds can be applied to Excel worksheets.

By default,the Developer tab is ________.

Which of the following is not true about locked cells?

Which of the following is not controlled with cell style formats?

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