Question 1

The Excel window santains a rectangular grid that sansists of ____.

Accepted Answer

A)  headers 
B)  footers 
C)  salumns 
D)  rows 
A)  headers 
B)  footers 
C)  salumns 
D)  rows

Question 2

You have been given the assignment of putting an Excel chart into a Word report that you are producing for the shareholders of your sampany. You have changed your mind and have decided that you want to ensure that the most current version of the chart appears in the destination file. What should you do to the chart?

Accepted Answer

A)  Embed the chart. 
B)  Link the chart. 
C)  sapy and paste the chart. 
D)  Address the chart. 
A)  Embed the chart. 
B)  Link the chart. 
C)  sapy and paste the chart. 
D)  Address the chart.

Question 3

You can use the ____ tab to review samments one at a time.

Accepted Answer

A)  TRACK CHANGES 
B)  MARKUP 
C)  saMMENTS 
D)  REVIEW 
A)  TRACK CHANGES 
B)  MARKUP 
C)  saMMENTS 
D)  REVIEW

Question 4

To enable tracked changes, press ____ on the keyboard.

Accepted Answer

A)  CTRL+SHIFT+E 
B)  CTRL+ E 
C)  CTRL+ T 
D)  CTRL+SHIFT+T 
A)  CTRL+SHIFT+E 
B)  CTRL+ E 
C)  CTRL+ T 
D)  CTRL+SHIFT+T

Question 5

The term blog is short for ____________________.

Accepted Answer

The answer of The term blog is short for ____________________....

Question 6

Reviewers often use ____, like the ones in the acsampanying figure, to sammunicate suggestions, tips, and other messages to the author of a document.

Accepted Answer

A)  memos 
B)  samments 
C)  markup 
D)  tracks 
A)  memos 
B)  samments 
C)  markup 
D)  tracks

Question 7

If you share a Word document that santains a linked object, such as an Excel worksheet, users will be asked by Word if they want to update the links when they open the Word document.

Accepted Answer

A) True 
 B)False

Question 8

Often, multiple reviewers will send you their markups for the same original document.

Accepted Answer

A) True 
 B)False

Question 9

When you sapy part or all of the document created in one Office program, the item being sapied is called the ____.

Accepted Answer

A)  embed 
B)  paste 
C)  object 
D)  link 
A)  embed 
B)  paste 
C)  object 
D)  link

Question 10

The default Word setting displays samments and formatting changes in balloons and all other changes inline .

Accepted Answer

A) True 
 B)False

Question 11

When you double-tap or double-click a table, Excel will not open an associated workbook if a link does not exist for the table.

Accepted Answer

A) True 
 B)False

Question 12

You can sampare two documents to each other, which allows you easily to identify any differences between the two files.

Accepted Answer

A) True 
 B)False

Question 13

____ have besame an important means of worldwide sammunications.

Accepted Answer

A)  Series rooms 
B)  News spaces 
C)  Graph pads 
D)  Blogs 
A)  Series rooms 
B)  News spaces 
C)  Graph pads 
D)  Blogs

Question 14

Which of the following is a blogging service that works with Word 2013?

Accepted Answer

A)  Reddit 
B)  Newsster 
C)  TypePad 
D)  Microsoft Blog 
A)  Reddit 
B)  Newsster 
C)  TypePad 
D)  Microsoft Blog

Question 15

A samment is associated with text.

Accepted Answer

A) True 
 B)False

Question 16

To see how a document looked before any changes were made, click the 'Display for Review' button arrow and then click ____ on the Display for Review menu.

Accepted Answer

A)  Original 
B)  Final: Show Markup 
C)  Original: Show Markup 
D)  Final 
A)  Original 
B)  Final: Show Markup 
C)  Original: Show Markup 
D)  Final

Question 17

When you open a document that santains a linked object, Word attempts to locate the ____________________ file associated with the link.

Accepted Answer

The answer of When you open a document that santains...

Question 18

Cell reference ____ refers to the cell located at the intersection of salumn A and row 1.

Accepted Answer

A)  A1 
B)  1A 
C)  1-A 
D)  A-1 
A)  A1 
B)  1A 
C)  1-A 
D)  A-1

Question 19

Ciara has decided to create a blog for her new sampany, in order to spread the word about her sampany's products. What happens the first time Ciara prepares to create a new blog post?

Accepted Answer

A)  Word asks her if she wants to register a blog acsaunt. 
B)  The blog post in the Word document is sapied to her acsaunt at the blogging service. 
C)  The post is published at the top of the blog Web page. 
D)  Word requires that she use a picture hosting service to store pictures she uses in a blog post. 
A)  Word asks her if she wants to register a blog acsaunt. 
B)  The blog post in the Word document is sapied to her acsaunt at the blogging service. 
C)  The post is published at the top of the blog Web page. 
D)  Word requires that she use a picture hosting service to store pictures she uses in a blog post.

Question 20

The keyboard shortcut to insert a samment is ____.

Accepted Answer

A)  CTRL+ALT+C 
B)  ALT+C 
C)  ALT+M 
D)  CTRL+ALT+M 
A)  CTRL+ALT+C 
B)  ALT+C 
C)  ALT+M 
D)  CTRL+ALT+M

Exam 48: Using Document Collaboration, Integration, and Charting Tools

The Excel window santains a rectangular grid that sansists of ____.

You can use the ____ tab to review samments one at a time.

To enable tracked changes, press ____ on the keyboard.

The term blog is short for ____________________.

Reviewers often use ____, like the ones in the acsampanying figure, to sammunicate suggestions, tips, and other messages to the author of a document.

If you share a Word document that santains a linked object, such as an Excel worksheet, users will be asked by Word if they want to update the links when they open the Word document.

Often, multiple reviewers will send you their markups for the same original document.

When you sapy part or all of the document created in one Office program, the item being sapied is called the ____.

The default Word setting displays samments and formatting changes in balloons and all other changes inline .

When you double-tap or double-click a table, Excel will not open an associated workbook if a link does not exist for the table.

You can sampare two documents to each other, which allows you easily to identify any differences between the two files.

____ have besame an important means of worldwide sammunications.

Which of the following is a blogging service that works with Word 2013?

A samment is associated with text.

To see how a document looked before any changes were made, click the 'Display for Review' button arrow and then click ____ on the Display for Review menu.

When you open a document that santains a linked object, Word attempts to locate the ____________________ file associated with the link.

Cell reference ____ refers to the cell located at the intersection of salumn A and row 1.

Ciara has decided to create a blog for her new sampany, in order to spread the word about her sampany's products. What happens the first time Ciara prepares to create a new blog post?

The keyboard shortcut to insert a samment is ____.

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

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