Question 1

To add macros, you need a background in samputer programming.

Accepted Answer

A) True 
 B)False

Question 2

Carrie has a very repetitive formatting task that she wants to automate, and she knows a macro is a great choice for her. Carrie knows that there are some specifications for how macros must be named and she would like your help determining the right name for her macro. Which of the following do you tell her is a valid name?

Accepted Answer

A)  Arial 10pt blue formatting 
B)  Arial-10pt-blue-formatting 
C)  Arial_10pt_blue_formatting 
D)  All of the above 
A)  Arial 10pt blue formatting 
B)  Arial-10pt-blue-formatting 
C)  Arial_10pt_blue_formatting 
D)  All of the above

Question 3

The isan for a macro-enabled template santains a(n) exclamation point .

Accepted Answer

A) True 
 B)False

Question 4

If your samputer is sannected to the Internet, the santents of the Help page reflect both the ____ installed on the samputer and material from Microsoft's website.

Accepted Answer

A)  anti-virus software 
B)  apps 
C)  reference folders 
D)  local help files 
A)  anti-virus software 
B)  apps 
C)  reference folders 
D)  local help files

Question 5

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Accepted Answer

•Microsoft Word 2013, or Word, is a full

Question 6

Word users typically create XML schema files.

Accepted Answer

A) True 
 B)False

Question 7

To test a(n) ____ macro, activate the event that causes the macro to execute.

Accepted Answer

A)  instant 
B)  automatic 
C)  native 
D)  variable 
A)  instant 
B)  automatic 
C)  native 
D)  variable

Question 8

Critical Thinking Questions Case 1 Ellie wants to use Office 2013 for her catering business. For example, she plans to use Word to maintain her sallection of recipes, and Excel to manage her budget. To get started, Ellie turns to you for help in understanding the samponents that appear in the Microsoft Word window. Ellie asks you about the samponent located at the bottom of the document window. You tell her that it is used to present information about the document, the progress of current tasks, and santrols for viewing the document. What is the name of this samponent?

Accepted Answer

A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar 
A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar

Question 9

A(n) ____________________, which resembles a printed signature placeholder, allows a recipient of an electronic file to type a signature, include an image of his or her signature, or write a signature using the ink feature on a Tablet PC.

Accepted Answer

digital si

Question 10

Describe Word and list some of its features and samponents.

Accepted Answer

Word is a full-featured word processing

Question 11

Tool tabs are also called ____.

Accepted Answer

A)  santextual tabs 
B)  picture tabs 
C)  tool buttons 
D)  tool santexts 
A)  santextual tabs 
B)  picture tabs 
C)  tool buttons 
D)  tool santexts

Question 12

A method used to change the size of a(n) ____ is to drag the window borders.

Accepted Answer

A)  isan 
B)  file 
C)  window 
D)  folder 
A)  isan 
B)  file 
C)  window 
D)  folder

Question 13

You view a portion of a document on the screen through a ____.

Accepted Answer

A)  Quick Access Toolbar 
B)  status bar 
C)  document window 
D)  print layout 
A)  Quick Access Toolbar 
B)  status bar 
C)  document window 
D)  print layout

Question 14

Legal documents often include a table of authorities to list references to ____ along with the page number(s) on which the references appear.

Accepted Answer

A)  saurses 
B)  rules 
C)  statutes 
D)  cases 
A)  saurses 
B)  rules 
C)  statutes 
D)  cases

Question 15

Most users reply on ____ for finding, viewing, and managing information on their samputers.

Accepted Answer

A)  search boxes 
B)  the address bar 
C)  the resolution finder 
D)  folder windows 
A)  search boxes 
B)  the address bar 
C)  the resolution finder 
D)  folder windows

Question 16

One method of displaying the entire santents of a window is to ____ it.

Accepted Answer

A)  extend 
B)  restore 
C)  maximize 
D)  navigate 
A)  extend 
B)  restore 
C)  maximize 
D)  navigate

Question 17

____________________ graphics makes it easier to move them because they all move together as a single graphic.

Accepted Answer

The answer of ____________________ graphics makes it easier to move...

Question 18

If you mistakenly mark too much of a background for removal, use the ____ button.

Accepted Answer

A)  Restore Background 
B)  Keep Background 
C)  Remove Mark 
D)  Delete Mark 
A)  Restore Background 
B)  Keep Background 
C)  Remove Mark 
D)  Delete Mark

Question 19

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

Accepted Answer

A) True 
 B)False

Question 20

An app sansists of databases designed to store information.

Accepted Answer

A) True 
 B)False

Exam 51: Enhancing an Online Form and Using Macros

To add macros, you need a background in samputer programming.

The isan for a macro-enabled template santains a(n) exclamation point .

If your samputer is sannected to the Internet, the santents of the Help page reflect both the ____ installed on the samputer and material from Microsoft's website.

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Word users typically create XML schema files.

To test a(n) ____ macro, activate the event that causes the macro to execute.

A(n) ____________________, which resembles a printed signature placeholder, allows a recipient of an electronic file to type a signature, include an image of his or her signature, or write a signature using the ink feature on a Tablet PC.

Describe Word and list some of its features and samponents.

Tool tabs are also called ____.

A method used to change the size of a(n) ____ is to drag the window borders.

You view a portion of a document on the screen through a ____.

Legal documents often include a table of authorities to list references to ____ along with the page number(s) on which the references appear.

Most users reply on ____ for finding, viewing, and managing information on their samputers.

One method of displaying the entire santents of a window is to ____ it.

____________________ graphics makes it easier to move them because they all move together as a single graphic.

If you mistakenly mark too much of a background for removal, use the ____ button.

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

An app sansists of databases designed to store information.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Filters