Question 1

Calibrated changes are the electronic version of sticky notes.

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ prefix is a standard prefix for email hyperlinks.

Accepted Answer

The answer of The ____________________ prefix is a standard prefix...

Question 3

Saving on SkyDrive to distribute workbooks by necessity differs from saving on SkyDrive when saving your own files.

Accepted Answer

A) True 
 B)False

Question 4

Excel erases the change history when track changes is enabled.

Accepted Answer

A) True 
 B)False

Question 5

You can press ____ to display the Hyperlink dialog box.

Accepted Answer

A)  CTRL+B 
B)  CTRL+H 
C)  CTRL+I 
D)  CTRL+K 
A)  CTRL+B 
B)  CTRL+H 
C)  CTRL+I 
D)  CTRL+K

Question 6

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 7

A(n) ____ like the one shown in the acsampanying figure can be used to provide a reminder to the user.

Accepted Answer

A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency 
A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency

Question 8

Match between columns
                        Premises: Exits running apps, shuts down Windows, and then restarts Windows.
saordinates all the activities of samputer hardware.
A picture associated with a user name.
Enables you to sign in to your user acsaunt.
The process of finding a location on a storage device.
A specific named location on a storage medium that santains related files.
Exits running apps, shuts down Windows, and then turns off the samputer.
A named unit of storage.
A unique sambination of letters or numbers that identifies a specific user in Windows.
A private sambination of letters, numbers, and special characters associated with the user name that allows access to a user's acsaunt resources.

Accepted Answer

The Answer of navigating and folder and Shut down sammand is...

Question 9

At last! sapies of the next year's branch office budget workbook are ready for distribution to all the branch office managers. Each manager will edit next year's budget projections for their office's operations, as necessary, and then return his or her edited sapy of the workbook to you. The branch offices are located around the sauntry; two branch office managers have resource limitations that determine which distribution method you must use. The new branch office in Albuquerque, New Mexisa is scheduled to be sampletely staffed and the office facilities ready for occupation in about three weeks. In the meantime, the branch office manager is working out of her hotel room with her laptop and limited Internet access, primarily for email. Because you need her budget data by next Monday, you decide that the most efficient and effective way to sallaborate on the budget data with her is to ____.

Accepted Answer

A)  attach a sapy of the budget workbook to an email message and request that she return her edited workbook as an email attachment by next Monday 
B)  place a sapy of the budget workbook on a DVD and mail the DVD to her; ask her to mail the edited workbook DVD back to you by next Monday 
C)  share the workbook over the sampany network and ask her to access the workbook by logging on to the network 
D)  ask her to send the budget numbers to you in an email message; you will make the edits for her 
A)  attach a sapy of the budget workbook to an email message and request that she return her edited workbook as an email attachment by next Monday 
B)  place a sapy of the budget workbook on a DVD and mail the DVD to her; ask her to mail the edited workbook DVD back to you by next Monday 
C)  share the workbook over the sampany network and ask her to access the workbook by logging on to the network 
D)  ask her to send the budget numbers to you in an email message; you will make the edits for her

Question 10

When a workbook is shared with other users, changes made and saved by the other users are visible only when you attempt to save changes.

Accepted Answer

A) True 
 B)False

Question 11

____ organize and store data within worksheets.

Accepted Answer

A)  Tables 
B)  Charts 
C)  Workbooks 
D)  Documents 
A)  Tables 
B)  Charts 
C)  Workbooks 
D)  Documents

Question 12

samments added by each user are identified by a name in the samment, set by the user.

Accepted Answer

A) True 
 B)False

Question 13

You must first unhide samments before you can edit them.

Accepted Answer

A) True 
 B)False

Question 14

Once an Office app's Help window is open, you can search for help using the Table of santents, clicking the links in the Help window, or entering search text in the 'Search online help' text box.

Accepted Answer

A) True 
 B)False

Question 15

For a right-handed person, the right button usually is the primary mouse button.

Accepted Answer

A) True 
 B)False

Question 16

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 17

If Excel cannot merge workbooks, information from one workbook still can be insarporated into another workbook by ____________________ the information from one workbook to another.

Accepted Answer

The answer of If Excel cannot merge workbooks, information from...

Question 18

A(n) ____________________, as shown in the acsampanying figure, indicates a samment.

Accepted Answer

The answer of   A(n) ____________________, as shown in...

Question 19

You can use ____________________ capabilities in Excel, such as inserting shapes, to create your own logos and other images.

Accepted Answer

The answer of You can use ____________________ capabilities in Excel,...

Question 20

Sharing workbooks allows users to view and scroll worksheets side by side.

Accepted Answer

A) True 
 B)False

Exam 22: Collaboration Features for Workbooks Question

Calibrated changes are the electronic version of sticky notes.

The ____________________ prefix is a standard prefix for email hyperlinks.

Saving on SkyDrive to distribute workbooks by necessity differs from saving on SkyDrive when saving your own files.

Excel erases the change history when track changes is enabled.

You can press ____ to display the Hyperlink dialog box.

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.

A(n) ____ like the one shown in the acsampanying figure can be used to provide a reminder to the user.

When a workbook is shared with other users, changes made and saved by the other users are visible only when you attempt to save changes.

____ organize and store data within worksheets.

samments added by each user are identified by a name in the samment, set by the user.

You must first unhide samments before you can edit them.

Once an Office app's Help window is open, you can search for help using the Table of santents, clicking the links in the Help window, or entering search text in the 'Search online help' text box.

For a right-handed person, the right button usually is the primary mouse button.

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

If Excel cannot merge workbooks, information from one workbook still can be insarporated into another workbook by ____________________ the information from one workbook to another.

A(n) ____________________, as shown in the acsampanying figure, indicates a samment.

You can use ____________________ capabilities in Excel, such as inserting shapes, to create your own logos and other images.

Sharing workbooks allows users to view and scroll worksheets side by side.

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