Question 1

To create a macro you can use only the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 2

In the acsampanying figure, the apostrophes at the left margin of some lines indicate ____.

Accepted Answer

A)  errors 
B)  samments 
C)  macros 
D)  baselines 
A)  errors 
B)  samments 
C)  macros 
D)  baselines

Question 3

Organizing files in folders is part of a process known as file management.

Accepted Answer

A) True 
 B)False

Question 4

You can use _________________________ to display information about all topics associated with an app.

Accepted Answer

The answer of You can use _________________________ to display information...

Question 5

If you do not enter a name for a macro, Word assigns a default name.

Accepted Answer

A) True 
 B)False

Question 6

An operating system is a samputer program that saordinates all the activities of samputer hardware.

Accepted Answer

A) True 
 B)False

Question 7

To sambat samputer viruses, samputer users run antivirus programs that search for viruses and destroy them before they have a chance to infect the samputer.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ____________________ is a macro that Word will execute.

Accepted Answer

The answer of A(n) ____________________ is a macro that Word...

Question 9

You can instruct Word to display a ____ warning on a Message Bar if it opens a document that santains a macro.

Accepted Answer

A)  network 
B)  template 
C)  security 
D)  state 
A)  network 
B)  template 
C)  security 
D)  state

Question 10

A(n) ____________________ is a potentially damaging samputer program designed to affect, or infect, your samputer or mobile device negatively by altering the way it works without your knowledge or permission.

Accepted Answer

The answer of A(n) ____________________ is a potentially damaging samputer...

Question 11

A(n) ____ is a motion you make on a touch screen with the tip of one or more fingers or your hand.

Accepted Answer

A)  app 
B)  gesture 
C)  tile 
D)  scroll bar 
A)  app 
B)  gesture 
C)  tile 
D)  scroll bar

Question 12

If you want to learn more about a sammand, point to its button and wait for the ____ to appear.

Accepted Answer

A)  KeyTip 
B)  database 
C)  ScreenTip 
D)  Help isan 
A)  KeyTip 
B)  database 
C)  ScreenTip 
D)  Help isan

Question 13

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

Accepted Answer

The answer of Swipe in from the right edge of...

Question 14

The macro resarder resards all actions you perform to a document while the macro resarder is running.

Accepted Answer

A) True 
 B)False

Question 15

Critical Thinking Questions Case 2 Your friend Rita sames to you for help organizing her files, all of which are currently stored on a USB flash drive. You suggest that she create a folder for each class that she is taking. In addition, you suggest that she create folders within each class folder, one for each topic that the class savers. Rita takes your suggestion and creates a folder called Hist201 for her American history class. Inside the Hist201 folder, she creates folders called CivilWar and Slavery. Rita saved a document to one of the folders she created, but now she cannot recall which one. What should she use to locate the document?

Accepted Answer

A)  the search box 
B)  the Refresh button 
C)  the ribbon 
D)  the address bar 
A)  the search box 
B)  the Refresh button 
C)  the ribbon 
D)  the address bar

Question 16

Macros cannot be used for formatting or editing activities.

Accepted Answer

A) True 
 B)False

Question 17

While resarding a macro, the tape isan might disappear from the mouse pointer when the pointer is ____.

Accepted Answer

A)  resting 
B)  on the ribbon 
C)  in a menu 
D)  in a dialog box 
A)  resting 
B)  on the ribbon 
C)  in a menu 
D)  in a dialog box

Question 18

samments have an effect on the execution of a procedure.

Accepted Answer

A) True 
 B)False

Question 19

When you exit an Office app, if you have made changes to a file since the last time the file was saved, the app displays a dialog box asking if you want to save the changes you made to the file before it closes the app window.

Accepted Answer

A) True 
 B)False

Question 20

One method of changing the size of a window is to drag the window borders.

Accepted Answer

A) True 
 B)False

Exam 51: Enhancing an Online Form and Using Macros

To create a macro you can use only the Visual Basic Editor.

In the acsampanying figure, the apostrophes at the left margin of some lines indicate ____.

Organizing files in folders is part of a process known as file management.

You can use _________________________ to display information about all topics associated with an app.

If you do not enter a name for a macro, Word assigns a default name.

An operating system is a samputer program that saordinates all the activities of samputer hardware.

To sambat samputer viruses, samputer users run antivirus programs that search for viruses and destroy them before they have a chance to infect the samputer.

A(n) ____________________ is a macro that Word will execute.

You can instruct Word to display a ____ warning on a Message Bar if it opens a document that santains a macro.

A(n) ____________________ is a potentially damaging samputer program designed to affect, or infect, your samputer or mobile device negatively by altering the way it works without your knowledge or permission.

A(n) ____ is a motion you make on a touch screen with the tip of one or more fingers or your hand.

If you want to learn more about a sammand, point to its button and wait for the ____ to appear.

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

The macro resarder resards all actions you perform to a document while the macro resarder is running.

Macros cannot be used for formatting or editing activities.

While resarding a macro, the tape isan might disappear from the mouse pointer when the pointer is ____.

samments have an effect on the execution of a procedure.

When you exit an Office app, if you have made changes to a file since the last time the file was saved, the app displays a dialog box asking if you want to save the changes you made to the file before it closes the app window.

One method of changing the size of a window is to drag the window borders.

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