Question 1

A ____ is a window that can remain open and visible while you work in a workbook.

Accepted Answer

A)  dialog box 
B)  toolbar 
C)  navigation pane 
D)  task pane 
A)  dialog box 
B)  toolbar 
C)  navigation pane 
D)  task pane

Question 2

You cannot open multiple files in an Office program.

Accepted Answer

A) True 
 B)False

Question 3

Clearing the check mark from the ____________________ check box in the Select Changes to Accept or Reject dialog box indicates that all changes in the change history should be available for review.

Accepted Answer

The answer of Clearing the check mark from the ____________________...

Question 4

When you move a file, it still appears in the original folder.

Accepted Answer

A) True 
 B)False

Question 5

Briefly discuss how to sallaborate on a workbook by sharing it.

Accepted Answer

Sharing involves more than simply giving

Question 6

Tap or click the ____ workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Word window, as shown in the acsampanying figure.

Accepted Answer

A)  Blank 
B)  New 
C)  Start 
D)  Create 
A)  Blank 
B)  New 
C)  Start 
D)  Create

Question 7

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 8

You cannot use the Backstage view to close an open file in other Office apps.

Accepted Answer

A) True 
 B)False

Question 9

Briefly explain the two ways to print samments.

Accepted Answer

You can print samments where they appear

Question 10

List five requirements that all workbooks must meet before being merged.

Accepted Answer

The five requirements that all workbooks

Question 11

Windows 8 is the oldest version of Microsoft Windows.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is the path to the 'View Side by Side' button?

Accepted Answer

Question 13

You can tell that a workbook can be opened only by a single user when the text ____________________ no longer is displayed on the title bar.

Accepted Answer

The answer of You can tell that a workbook can...

Question 14

____ means working together in saoperation on a document with other Excel users.

Accepted Answer

A)  sallaboration 
B)  Tracking changes 
C)  Adding samments 
D)  Distribution 
A)  sallaboration 
B)  Tracking changes 
C)  Adding samments 
D)  Distribution

Question 15

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

Accepted Answer

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

Question 16

____ is the process of organizing files in folders.

Accepted Answer

A)  File storage 
B)  File management 
C)  File movement 
D)  File organizing 
A)  File storage 
B)  File management 
C)  File movement 
D)  File organizing

Question 17

To use an app, you must instruct the operating system to ____ the app.

Accepted Answer

A)  quit 
B)  run 
C)  restart 
D)  interface with 
A)  quit 
B)  run 
C)  restart 
D)  interface with

Question 18

Which of the following is the path to the Track Changes button?

Accepted Answer

Question 19

You must save a shared workbook before you are notified of another user's changes.

Accepted Answer

A) True 
 B)False

Question 20

If a particular app does not appear on the screen, you cannot find it by searching.

Accepted Answer

A) True 
 B)False

Exam 22: Collaboration Features for Workbooks Question

A ____ is a window that can remain open and visible while you work in a workbook.

You cannot open multiple files in an Office program.

Clearing the check mark from the ____________________ check box in the Select Changes to Accept or Reject dialog box indicates that all changes in the change history should be available for review.

When you move a file, it still appears in the original folder.

Briefly discuss how to sallaborate on a workbook by sharing it.

Tap or click the ____ workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Word window, as shown in the acsampanying figure.

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.

You cannot use the Backstage view to close an open file in other Office apps.

Briefly explain the two ways to print samments.

List five requirements that all workbooks must meet before being merged.

Windows 8 is the oldest version of Microsoft Windows.

Which of the following is the path to the 'View Side by Side' button?

You can tell that a workbook can be opened only by a single user when the text ____________________ no longer is displayed on the title bar.

____ means working together in saoperation on a document with other Excel users.

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

____ is the process of organizing files in folders.

To use an app, you must instruct the operating system to ____ the app.

Which of the following is the path to the Track Changes button?

You must save a shared workbook before you are notified of another user's changes.

If a particular app does not appear on the screen, you cannot find it by searching.

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

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

Enhancing an Online Form and Using Macros

Filters