Question 1

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 2

Which of the following is not a default cell style?

Accepted Answer

A) Standard 
B) Bad 
C) Good 
D) Neutral 
A) Standard 
B) Bad 
C) Good 
D) Neutral

Question 3

What is the default save location for templates?

Accepted Answer

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

Question 4

By default,the macro recorder uses absolute references.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is the proper beginning for a sub procedure named "Test"?

Accepted Answer

A) Sub () 
B) Sub (Test) 
C) (Test) 
D) Sub Test() 
A) Sub () 
B) Sub (Test) 
C) (Test) 
D) Sub Test()

Question 6

Locked cells cannot be ________.

Accepted Answer

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

Question 7

An image used to classify a document as confidential can be placed as a custom ________ in a workbook.

Accepted Answer

The answer of An image used to classify a document...

Question 8

Which of the formats below will not support sub procedures using VBA?

Accepted Answer

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

Question 9

Match between columns
                        Premises: Visual Basic for Applications
Sub procedure
Module
Object
Run Time Error

Accepted Answer

The Answer of A software or hardware problem that prevents is...

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

Where are Trust Center options located?

Accepted Answer

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

Question 12

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

Accepted Answer

The Answer of An application used to create,edit,execute,and debug Office is...

Question 13

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 14

Which of the following objects can be used to launch a macro?

Accepted Answer

A) Chart 
B) Function 
C) Image 
D) Hyperlink 
A) Chart 
B) Function 
C) Image 
D) Hyperlink

Question 15

Match between columns
                        Premises: Password
Unlocked cell
Protected worksheet
Unprotected worksheet
Locked cell

Accepted Answer

The Answer of A cell that prevents users from editing is...

Question 16

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 17

Which of the following is not a best practice when creating a macro?

Accepted Answer

A) Practice the steps before starting 
B) Determine whether absolute or relative references should be used 
C) Start and stop the recording as needed 
D) Ensure the macros are broad enough to apply to multiple situations 
A) Practice the steps before starting 
B) Determine whether absolute or relative references should be used 
C) Start and stop the recording as needed 
D) Ensure the macros are broad enough to apply to multiple situations

Question 18

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 19

What are the benefits of using macros?

Accepted Answer

Macros have the ability to automatically

Question 20

By default,macros in Excel are ________.

Accepted Answer

The answer of By default,macros in Excel are ________....

Exam 29: Excel: Templates, styles, and Macros

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

Which of the following is not a default cell style?

What is the default save location for templates?

By default,the macro recorder uses absolute references.

Which of the following is the proper beginning for a sub procedure named "Test"?

Locked cells cannot be ________.

An image used to classify a document as confidential can be placed as a custom ________ in a workbook.

Which of the formats below will not support sub procedures using VBA?

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

Where are Trust Center options located?

Which of the following is true about a protected worksheet?

Which of the following objects can be used to launch a macro?

What is the default reference type when recording a macro?

Which of the following is not a best practice when creating a macro?

Which of the following is a method for creating macros?

What are the benefits of using macros?

By default,macros in Excel are ________.

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