Question 1

Worksheets and charts are examples of Excel _______.
A) OLEs
B) links
C) objects
D) workbooks

Accepted Answer

Worksheets and charts are examples of objects within an Excel workbook. OLEs refer to objects embedded from other programs, links refer to references to external data, and workbooks refer to the entire file containing multiple worksheets and objects.

Question 2

You can accept all the edits in a document by clicking the Accept button arrow, and then clicking _______.
A) Accept All Edits
B) Accept All Changes in Document
C) Accept Changes
D) Agree to All Changes

Accepted Answer

The correct option is "Accept All Changes in Document." This is the command used in word processing software, such as Microsoft Word, to accept all tracked changes in a document at once.

Question 3

A technology called _______ allows you to integrate information created in one program into a document created in another program.
A) HTML
B) HTTP
C) OLE
D) FTP

Accepted Answer

OLE (Object Linking and Embedding) is a technology that allows for the integration of information created in one program (such as a spreadsheet) to be embedded or linked to a document created in another program (such as a word processor). This allows for more efficient and effective use of different software applications together.

Question 4

A spreadsheet created in Microsoft Excel is known as a _______.
A) table
B) database
C) workbook
D) worksheet

Accepted Answer

The answer of A spreadsheet created in Microsoft Excel is...

Question 5

When the default settings for Insertions in the Advanced Track Changes Options dialog box is set to _______, this means that Word assigns one color to each person who edits the document.
A) By editor
B) By creator
C) By writer
D) By author

Accepted Answer

The answer of When the default settings for Insertions in...

Question 6

The _______ object is a shortcut to the original object in the source file.
A) linked
B) embedded
C) pasted
D) imported

Accepted Answer

The linked object is a shortcut to the original object in the source file. It allows the user to make changes to the original file and have those changes automatically reflected in the document where the linked object is inserted. Embedded objects, on the other hand, are actually copied and inserted into the document, while pasted objects are copied from one document and pasted into another, and imported objects are files that are brought into a document from an external source.

Question 7

In OLE, the file into which you integrate the object is called the _______ file.
A) source
B) destination
C) terminating
D) end

Accepted Answer

In OLE, the file or document where an object is inserted or integrated is referred to as the destination file. The source file is the original file containing the object to be inserted.

Question 8

To accept an individual change, you click the _______ button.
A) Change
B) Modify
C) Accept
D) Adjust Document

Accepted Answer

To accept an individual change, you click the "Accept" button.

Question 9

A(n) _______ program allows you to organize, calculate, and analyze numerical data.
A) analysis
B) spreadsheet
C) database
D) OLE

Accepted Answer

A spreadsheet program, such as Microsoft Excel, allows you to organize numerical data into rows and columns, perform calculations and formulas, and create charts and graphs to analyze the data. Analysis programs (A) may be used for this purpose as well, but are more specialized and may not have the same level of flexibility and functionality as spreadsheet programs. Database programs (C) are used to store and manage large amounts of data, but may not have the same analytical capabilities as spreadsheet programs. OLE (D) stands for Object Linking and Embedding, a technology used to share data between different programs, but is not a program itself.

Question 10

The original file in OLE is called the _______ file.
A) source
B) destination
C) origin
D) originating

Accepted Answer

The source file is the original file that is embedded or linked in an OLE object.

Question 11

When you have two different versions of a document and you want to see the differences between the two, use the _______ feature.
A) Track Changes
B) Compare
C) Combine
D) Merge

Accepted Answer

The Compare feature is specifically designed to show the differences between two versions of a document, while the other options may not provide the same level of detail in highlighting changes.

Question 12

To begin accepting and rejecting tracked changes in a document, move the insertion point to the _______ of the document.
A) end
B) beginning
C) middle
D) heading

Accepted Answer

Moving the insertion point to the beginning of the document allows the user to systematically review each change made throughout the document from start to finish.

Question 13

Which of the following is an option for rejecting changes?
A) Reject All Changes in Document
B) Delete All Revisions Shown
C) Delete All Revisions in Document
D) Deny All Changes as Shown

Accepted Answer

Reject All Changes in Document is the best option as it will reject all tracked changes in the document at once, making it the most efficient option. The other options only delete or deny specified changes, which may not be as useful if there are many revisions in the document.

Question 14

If you edit the original file in the source program, those changes appear in the _______ object.
A) linked
B) embedded
C) pasted
D) imported

Accepted Answer

Changes made in the source program will only reflect in the linked object, as the file is linked to the original source. Embedded, pasted, and imported objects are separate from the source program and do not update if changes are made in the source program.

Question 15

The Track Changes button is highlighted in _______, indicating that the Track Changes feature is turned on.
A) red
B) orange
C) green
D) blue

Accepted Answer

In Microsoft Word, the Track Changes button is highlighted in blue when the Track Changes feature is turned on. Therefore, the best choice is D.

Question 16

In the accompanying figure, the item marked 1 displays the _______ program, Excel.
A) source
B) destination
C) target
D) bookmark

Accepted Answer

The item marked 1 in the figure is displaying the source program, which is Excel. Therefore, option A, "source," is the correct choice. Option B, "destination," refers to the location or endpoint of a transfer, while option C, "target," refers to the object of the transfer. Option D, "bookmark," refers to a saved location in a document or program.

Question 17

Press _______ to move the insertion point to the beginning of the document.
A) Ctrl+Page Up
B) Shift+Page Up
C) Ctrl+Home
D) Shift+Home

Accepted Answer

Ctrl+Home is the shortcut to move the insertion point to the beginning of the document.

Question 18

Just as with an embedded object, you can double-click a linked object to access the tools of the _______ program.
A) origin
B) end
C) source
D) destination

Accepted Answer

When you link an object, it is connected to its source or origin program. Double-clicking on the linked object will bring up the tools of the source program, allowing you to make changes to the object from within that program. Therefore, the correct choice is C - source.

Question 19

The program used to create the original version of an object is called the _______ program.
A) source
B) destination
C) origin
D) originating

Accepted Answer

The program used to create the original version of an object is referred to as the source program. This is because it contains the source code that defines how the object behaves and operates.

Question 20

The _______ tab contains all the options you need for working with tracked changes.
A) REVIEW
B) CHANGES
C) EDITING
D) TRACKING

Accepted Answer

The REVIEW tab in Microsoft Word is where all the options for working with tracked changes can be found. It allows you to accept or reject changes, add comments, and compare different versions of a document. The CHANGES tab does not exist in Microsoft Word, and while the EDITING and TRACKING tabs may have some related options, they do not encompass all the necessary features for working with tracked changes.

Quiz 13: Word: Collaborating With Others and Integrating Data

Worksheets and charts are examples of Excel _______.

You can accept all the edits in a document by clicking the Accept button arrow, and then clicking _______.

A technology called _______ allows you to integrate information created in one program into a document created in another program.

A spreadsheet created in Microsoft Excel is known as a _______.

When the default settings for Insertions in the Advanced Track Changes Options dialog box is set to _______, this means that Word assigns one color to each person who edits the document.

The _______ object is a shortcut to the original object in the source file.

In OLE, the file into which you integrate the object is called the _______ file.

To accept an individual change, you click the _______ button.

A(n) _______ program allows you to organize, calculate, and analyze numerical data.

The original file in OLE is called the _______ file.

When you have two different versions of a document and you want to see the differences between the two, use the _______ feature.

To begin accepting and rejecting tracked changes in a document, move the insertion point to the _______ of the document.

Which of the following is an option for rejecting changes?

If you edit the original file in the source program, those changes appear in the _______ object.

The Track Changes button is highlighted in _______, indicating that the Track Changes feature is turned on.

In the accompanying figure, the item marked 1 displays the _______ program, Excel.

Press _______ to move the insertion point to the beginning of the document.

Just as with an embedded object, you can double-click a linked object to access the tools of the _______ program.

The program used to create the original version of an object is called the _______ program.

The _______ tab contains all the options you need for working with tracked changes.