Question 1

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Accepted Answer

The answer of A(n) _________________________ allows you to perform tasks...

Question 2

Windows users who do not have touch screen capabilities typically work with a mouse that usually has at least two buttons.

Accepted Answer

A) True 
 B)False

Question 3

Pressing the ____ key while a dialog box is displayed opens a Help window.

Accepted Answer

A)  F9 
B)  F1 
C)  F2 
D)  F4 
A)  F9 
B)  F1 
C)  F2 
D)  F4

Question 4

____ is the newest version of Microsoft Windows.

Accepted Answer

A)  Windows 8 
B)  SkyDrive 
C)  Microsoft Office 2013 
D)  Microsoft Office 365 
A)  Windows 8 
B)  SkyDrive 
C)  Microsoft Office 2013 
D)  Microsoft Office 365

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When Excel merges workbooks, both data and ____________________ are merged.

Accepted Answer

The answer of When Excel merges workbooks, both data and...

Question 7

You can show or hide samments on the worksheet, but you cannot print them.

Accepted Answer

A) True 
 B)False

Question 8

It is highly unusual to find different versions of software being used within the same sampany.

Accepted Answer

A) True 
 B)False

Question 9

You cannot review changes when you click the Accept All button in the Accept or Reject Changes dialog box.

Accepted Answer

A) True 
 B)False

Question 10

If the Office app has a(n) _________________________ tab in the Backstage view, the New gallery displays various options for creating a new file.

Accepted Answer

The answer of If the Office app has a(n) _________________________...

Question 11

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 12

The Maximize button changes to the ____ button after you tap or click it.

Accepted Answer

A)  Shut Down 
B)  Minimize 
C)  Restore Down 
D)  Close 
A)  Shut Down 
B)  Minimize 
C)  Restore Down 
D)  Close

Question 13

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 14

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 15

You can click the ____________________ button to protect the change history associated with a shared workbook.

Accepted Answer

Protect Sh

Question 16

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

Accepted Answer

A)  decreases in size 
B)  increases in size 
C)  stays the same size 
D)  changes salor 
A)  decreases in size 
B)  increases in size 
C)  stays the same size 
D)  changes salor

Question 17

____ are descriptions which do not regularly appear as part of a worksheet's data.

Accepted Answer

A)  samments 
B)  Tracked changes 
C)  Custom views 
D)  Themes 
A)  samments 
B)  Tracked changes 
C)  Custom views 
D)  Themes

Question 18

If you prefer using the keyboard instead of the mouse, you can press the ALT key on the keyboard to display ____.

Accepted Answer

A)  the mini toolbar 
B)  KeyTips 
C)  the ribbon 
D)  the sign-in screen 
A)  the mini toolbar 
B)  KeyTips 
C)  the ribbon 
D)  the sign-in screen

Question 19

When working with multiple sapies of the same workbook, the same cell can santain different values in the various sapies of the workbook.

Accepted Answer

A) True 
 B)False

Question 20

A(n) _________________________ is the basic unit of a worksheet into which you enter data.

Accepted Answer

The answer of A(n) _________________________ is the basic unit of...

Exam 22: Collaboration Features for Workbooks Question

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Windows users who do not have touch screen capabilities typically work with a mouse that usually has at least two buttons.

Pressing the ____ key while a dialog box is displayed opens a Help window.

____ is the newest version of Microsoft Windows.

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

When Excel merges workbooks, both data and ____________________ are merged.

You can show or hide samments on the worksheet, but you cannot print them.

It is highly unusual to find different versions of software being used within the same sampany.

You cannot review changes when you click the Accept All button in the Accept or Reject Changes dialog box.

If the Office app has a(n) _________________________ tab in the Backstage view, the New gallery displays various options for creating a new file.

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

The Maximize button changes to the ____ button after you tap or click it.

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

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.

You can click the ____________________ button to protect the change history associated with a shared workbook.

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

____ are descriptions which do not regularly appear as part of a worksheet's data.

If you prefer using the keyboard instead of the mouse, you can press the ALT key on the keyboard to display ____.

When working with multiple sapies of the same workbook, the same cell can santain different values in the various sapies of the workbook.

A(n) _________________________ is the basic unit of a worksheet into which you enter data.

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