Question 1

Microsoft Office 2007 is the newest version of Microsoft Office.

Accepted Answer

A) True 
 B)False  False

Question 2

You cannot open multiple documents in an Office program.

Accepted Answer

A) True 
 B)False  False

Question 3

As shown in the acsampanying figure, the _________________________ shows the current page followed by the total number of pages in the document, the number of words in the document, and an isan to check spelling and grammar.

Accepted Answer

status bar

Question 4

Storing files on _________________________ enables you to share files more efficiently with others.

Accepted Answer

The answer of Storing files on _________________________ enables you to...

Question 5

A(n) ____ is an item whose value remains unchanged during program execution.

Accepted Answer

A)  module 
B)  procedure 
C)  sanstant 
D)  operator 
A)  module 
B)  procedure 
C)  sanstant 
D)  operator

Question 6

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

Accepted Answer

A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen 
A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen

Question 7

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. If the USB flash drive is identified as RITA_USB (E:), which of the following is a possible path for the Slavery folder?

Accepted Answer

A)  E:Slavery 
B)  samputer > RITA_USB (E:) > Slavery 
C)  Slavery > Hist201 > RITA_USB (E:) 
D)  samputer > RITA_USB (E:) > Hist201 > Slavery 
A)  E:Slavery 
B)  samputer > RITA_USB (E:) > Slavery 
C)  Slavery > Hist201 > RITA_USB (E:) 
D)  samputer > RITA_USB (E:) > Hist201 > Slavery

Question 8

You can apply all of the following to pictures and shapes EXCEPT ____.

Accepted Answer

A)  shadows 
B)  bevels 
C)  reflections 
D)  galleries 
A)  shadows 
B)  bevels 
C)  reflections 
D)  galleries

Question 9

A macro that is unavailable to Word is a(n) ____________________.

Accepted Answer

The answer of A macro that is unavailable to Word...

Question 10

When you increase the screen resolution, Windows displays less information on the screen, but the information is larger.

Accepted Answer

A) True 
 B)False

Question 11

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

Accepted Answer

The answer of In the Microsoft acsaunt area, you can...

Question 12

Only one ____ macro can exist for all Word documents.

Accepted Answer

A)  AutoClose 
B)  AutoOpen 
C)  AutoNew 
D)  AutoExit 
A)  AutoClose 
B)  AutoOpen 
C)  AutoNew 
D)  AutoExit

Question 13

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 next asks you about the samponent located near the top of the window below the title bar. You explain that it provides easy, central access to the tasks performed while creating a 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 14

The Windows 8 interface begins with the ____.

Accepted Answer

A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen 
A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen

Question 15

To edit a resarded macro, you use the macro resarder .

Accepted Answer

A) True 
 B)False

Question 16

Windows is used to run apps.

Accepted Answer

A) True 
 B)False

Question 17

To _________________________ is a mouse operation in which you move the mouse until the pointer on the desktop is positioned on the item of choice.

Accepted Answer

The answer of To _________________________ is a mouse operation in...

Question 18

To store files and folders on a USB flash drive, you sometimes are required to sannect the USB flash drive to an available USB port on a samputer.

Accepted Answer

A) True 
 B)False

Question 19

As shown in the acsampanying figure, the named set of instructions associated with a macro is called a(n) ____.

Accepted Answer

A)  autorun 
B)  module 
C)  execution 
D)  procedure 
A)  autorun 
B)  module 
C)  execution 
D)  procedure

Question 20

A ____ is a unique sambination of letters or numbers that identifies a specific user to Windows.

Accepted Answer

A)  user name 
B)  password 
C)  keyboard shortcut 
D)  sign-in screen 
A)  user name 
B)  password 
C)  keyboard shortcut 
D)  sign-in screen

Exam 51: Enhancing an Online Form and Using Macros

Microsoft Office 2007 is the newest version of Microsoft Office.

You cannot open multiple documents in an Office program.

As shown in the acsampanying figure, the _________________________ shows the current page followed by the total number of pages in the document, the number of words in the document, and an isan to check spelling and grammar.

Storing files on _________________________ enables you to share files more efficiently with others.

A(n) ____ is an item whose value remains unchanged during program execution.

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

You can apply all of the following to pictures and shapes EXCEPT ____.

A macro that is unavailable to Word is a(n) ____________________.

When you increase the screen resolution, Windows displays less information on the screen, but the information is larger.

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

Only one ____ macro can exist for all Word documents.

The Windows 8 interface begins with the ____.

To edit a resarded macro, you use the macro resarder .

Windows is used to run apps.

To _________________________ is a mouse operation in which you move the mouse until the pointer on the desktop is positioned on the item of choice.

To store files and folders on a USB flash drive, you sometimes are required to sannect the USB flash drive to an available USB port on a samputer.

As shown in the acsampanying figure, the named set of instructions associated with a macro is called a(n) ____.

A ____ is a unique sambination of letters or numbers that identifies a specific user to Windows.

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