Deck 11: Excell: Collaborating With Others and Preparing a Workbook for Distribution

Question 1

The change history includes the name of the person who made each change,when the change was made,and ________.

A)what data was changed
B)what file was changed
C)what feature was changed
D)what history was changed

Answer 1

A

Question 2

The change history worksheet does NOT display when you ________.

A)turn off view mode
B)turn off silent mode
C)turn off review mode
D)turn off Track changes

Answer 2

D

Question 3

Once the changes are recorded,you can review the shared file and decide to ________.

A)delete the file
B)discard the file
C)accept or reject the changes
D)refresh the changes

Answer 3

C

Question 4

Details about the Excel workbook that describe or identify the file,including the title,author name,subject,and keywords that identify the file's topic or contents,are called ________.

A)properties
B)documents
C)shared information
D)identifiers

Question 5

As others make changes to a shared workbook,you can view and track the changes they make by viewing the details in the ________.

A)shared history
B)tracking history
C)review history
D)change history

Question 6

If the Read-only property is selected,the file can be read or copied,but NOT ________.

A)changed or saved
B)zoomed out
C)viewed in page layout view
D)deleted

Question 7

The read-only property CANNOT be set while the file is ________.

A)deleted
B)read
C)open
D)saved

Question 8

The change history information includes the name of ________,when the change was made,and what data was changed.

A)the computer that was used
B)the file that was opened
C)the person who made the change
D)the folder that was opened

Question 9

In a shared network environment,using the Contact Card option,you could do the following with certain authors of the spreadsheet: ________.

A)reply to an email
B)open Word
C)send an email
D)add an address file

Question 10

After a proposed change is accepted or rejected,which of the following is removed from the cell?

A)The tracking notation
B)The cell's value
C)The triangle
D)The changes

Question 11

A faded image or text used as a background of a document is ________.

A)alt-text
B)a watermark
C)a draft
D)an imprint

Question 12

If you receive a file from someone else,which you then modify and use,the original author's name ________.

A)is replaced by a search engine
B)remains with the file
C)is replaced by your name
D)is saved in a different file

Question 13

When more than one copy of the shared workbook contains marked changes,first ________ the workbooks so that you can view everyone's changes in a single workbook.

A)merge
B)save
C)accept
D)discard

Question 14

Workbooks that enable multiple users on a network to view and make changes to the workbook at the same time are called shared ________.

A)worksheets
B)workbooks
C)views
D)programs

Question 15

Within the Properties dialog box for a file on the General Tab,there are additional properties that can be viewed and changed,such as ________.

A)protection parameters
B)keywords
C)backstage options
D)the date the file was last accessed

Question 16

To view details about workbook changes,including insertions and deletions,you can control the collaboration process by using Excel's ________.

A)collaboration feature
B)highlight feature
C)review changes feature
D)Track Changes feature

Question 17

The Author name area is generated from ________.

A)the last time you accessed the file
B)the computer where you stored the file
C)your current computer
D)the computer where the file originated

Question 18

In a shared workbook,information that is maintained about changes made in past editing sessions is called the ________.

A)track history
B)change history
C)save history
D)review history

Question 19

A network within an organization that uses Internet technologies is known as ________.

A)an intranet
B)an inter Internet
C)a superhighway
D)a webnet

Question 20

To change a file to Read-only,display the file list in File Explorer,right-click on the file name,and then click ________.

A)Rename
B)Delete
C)Properties
D)Create shortcut

Question 21

By scrambling the contents of a file,you are using ________ to restrict access to the file.

A)the Mark as Final command
B)cloud computing
C)a Microsoft Account
D)encryption

Question 22

The Accept/Reject Changes option is located on the ________.

A)Insert Tab
B)Review Tab
C)View Tab
D)Formulas Tab

Question 23

When you create your own digital certificate,it is referred to as a ________.

A)public project
B)private project
C)self-signed project
D)self-implied project

Question 24

Mark as Final signifies the intent of the author that the document is finalized and makes the document ________.

A)password protected
B)read only
C)ready to edit
D)ready to save

Question 25

Before sharing a workbook with others,you can make the document read-only by applying the ________.

A)Archive command
B)Inspect Document command
C)Mark as Final command
D)Read-only command

Question 26

To edit a Marked as Final workbook in Excel,you click on the ________.

A)Final button
B)Save button
C)Edit Anyway button
D)Read-only button

Question 27

The Mark as Final command prevents ________.

A)additional changes to the document
B)the user from reading the file
C)the file from opening
D)anyone from saving the file

Question 28

You can accept or reject changes without your own actions being recorded as a change by selecting ________.

A)No One but Me
B)Only Me
C)Everyone
D)Everyone but Me

Question 29

Previous sharing sessions are no longer available if you ________.

A)copy a session
B)restart a shared session
C)record a session
D)do NOT save your session

Question 30

Within a document,which of the following specifies that an individual must digitally sign the document?

A)Signature line
B)A block
C)A triangle
D)A "DS" square

Question 31

After the changes have been reviewed,before the workbook can be published,which of the following must be removed from the workbook?

A)The review features
B)The users' name
C)The Shared designation
D)The Track Changes notation

Question 32

Like a driver's license,digital certificates can expire or be revoked and are issued by a ________.

A)license bureau
B)security officer
C)computer authority
D)certificate authority

Question 33

Which of the following finds potential issues for users with disabilities so that you can resolve the issues and make your file easier to use?

A)Compatibility Checker
B)Document Inspector
C)Accessibility Checker
D)Compatibility Mode

Question 34

Removing the Shared designation from a workbook also will turn off which feature?

A)Track Changes
B)Indicator Changes
C)Review Changes
D)Reject Changes

Question 35

A digital certificate works by providing ________.

A)private pairs
B)a public key pair
C)an encrypted certificate pair
D)a cryptographic key pair

Question 36

A digital signature is authenticated by the ________.

A)name on the signature
B)source of the signature
C)file of the signature
D)target of the signature

Question 37

To ensure that a workbook CANNOT be edited,you must ________.

A)click the Edit Anyway button
B)rename the workbook
C)password protect the workbook
D)apply the Mark as Final status

Question 38

Which of the following is the command that makes a document read-only?

A)Document Inspector
B)Encryption
C)Mark as Final
D)Properties Inspector

Question 39

Encryption is more than simple password protection;it prevents users from ________.

A)saving the file
B)deleting the file
C)editing the file
D)opening the file

Question 40

Which of the following finds and removes hidden properties and personal information from a workbook?

A)Properties Finder
B)Track Changes
C)Document Inspector
D)Encryption

Question 41

If you need to edit a read-only file,save it with the same file name,which preserves the original file.

Question 42

Collaboration refers to the process of working together with others to view.

Question 43

When you share a workbook with others,you control the collaboration process by using Excel's Track Changes feature.

Question 44

You can provide another level of security for your workbook by adding encryption.

Question 45

You can change file properties before the file is distributed so that the recipients will know who distributed the file.

Question 46

To digitally sign an Office document,you must obtain a digital certificate from the computer authority bureau.

Question 47

You can accept or reject changes without your own actions being recorded as a change by selecting No One but Me.

Question 48

For individuals who do NOT have access to the network,you can make a copy of the shared workbook and send it to them by email.

Question 49

As others make changes to a shared workbook,you can view and track the changes by viewing the Document Inspector.

Question 50

A network within an organization is known as an Internet.

Question 51

Changes CANNOT be made to a shared workbook when it is opened.

Question 52

After the changes have been reviewed and before the workbook is published,the Shared designation must be discarded from the workbook.

Question 53

Encryption is more than simple password protection-it will digitally obscure information to make it unreadable without a proper key to decode it.

Question 54

In Backstage view,some of the properties displayed on the Info tab can be changed,and you can add titles,tags,or categories.

Question 55

The Track Changes features finds and removes hidden properties and personal information from a workbook.

Question 56

When more than one copy of a shared workbook contains marked changes,first merge the workbooks so you can review all the changes in a single workbook.

Question 57

A digital means of proving identity and authenticity in a document is known as a digital license.

Question 58

A digital ID is needed to insert an actual digital signature.

Question 59

Every Excel workbook file has properties.

Question 60

As others make changes to a shared workbook,you can view and track the changes made by viewing the details in the change history.

Question 61

To digitally sign an Office document,you must have a digital ________,which proves identity.

Question 62

For individuals who do NOT have access to the network,you can make a copy of a shared workbook and send it to them via ________.

Question 63

Excel workbook files have ________,which contain details about a file that describe or identify the file,including the title and author name.

Question 64

An encrypted file CANNOT be opened without a password.

Question 65

The process of working jointly with others to review,comment on,and make changes to a shared workbook is known as ________.

Question 66

After changes are made to a copy of a shared workbook,it can be ________ with the original shared workbook.

Question 67

Details that identify a file's properties are also known as ________.

Question 68

To change the Attributes area in the Properties dialog box of a file,the file must be ________.

Question 69

A ________ document is a type of document that has an unauthenticated certificate that was created by the signer of the document.

Question 70

Encrypting a file will digitally inspect information.

Question 71

If your workbook is password protected,it can be opened without a password.

Question 72

When you create your own ________,it is referred to as a self-signed project.

Question 73

The change history worksheet displays only when a worksheet is in ________ mode.

Question 74

There is no way to recover a mistyped password from an encrypted document.

Question 75

A network within an organization that uses Internet technologies is called an ________.

Question 76

You can obtain a digital certificate from a certificate ________,a commercial organization that issues digital certificates,keeps track of who is assigned to a certificate,and tracks which certificates are expired or revoked.

Question 77

When you activate the Track Changes feature,the workbook automatically becomes a ________ workbook.

Question 78

A ________ signature is a stamp of authentication.

Question 79

A ________ line specifies that an individual must digitally sign the document.

Question 80

The Mark as Final command is a security feature.