Excel Lesson 11
undo
Undo is inactive in a shared workbook. If you accidentally replace your data or another user's data, you need to reject the change to restore the data you replaced.
user
When a _______ opens a shared workbook, he or she can see the changes made and saved by other users
on
When you open a shared workbook, Track Changes is automatically turned _____.
customize
You can ___________ the Track Changes feature to track specific types of changes, you can allow the feature to be turned on and off at will by various users, or you can specify a password to protect the changes.
Track changes, share workbook, protect and share workbook
You can turn on change tracking using the _______ ___________ command, the __________ __________ command, or the ___________ _____ _________ ____________ command (all located on the REVIEW tab).
first
You would have to unprotect the workbook _________ to run the Document Inspector.
off
In most cases, the workbook owner has entered a password to prevent a user from turning _____ Track Changes. Thus, any text you type in the workbook is tracked.
copy
It is a good idea to perform an inspection on a _______ of your workbook because you might not be able to restore hidden content that you remove in the inspection process.
changes
Note that when you work in a network environment, you can click Share Workbook in the ________ group and see a list of other users who have the workbook open.
do not
On a network, you ___ ______ see changes made by other users until both they and you save your changes.
at end of sheet
To print comments on a separate page, select ___ _____ ___ ________ in the Comments box on the Sheet tab of the Page Setup dialog box.
Values
To retain the Employee ID numbers created by the formula for RANDBETWEEN, you must replace the formula with the ________
Save Ctrl S
To save your changes to a shared workbook and to see the changes that other users have saved since your last save, click ______ on the Quick Access Toolbar or choose other save options such as _______ + __
off remain
Turning ____ Track Changes removes the change history and removes the shared status of the workbook, but changes already shown in the document will _______ until you accept or reject them.
Track changes, update changes, Conflicting changes between users, include in personal view
What four options does the advanced tab contain
Comments and annotations, document properties and personal information, headers and footers, hidden rows columns and worksheets
What types of hidden data and personal information can be saved in an excel workbook?
resolve conflicts
When the second user tries to save the workbook, Excel displays the ________ ___________ dialog box.
Protected
When you __________ your shared workbook, you prevented those who use the workbook from removing the change history.
attatchment
When you add Sent to Mail Recipient command to the toolbar, you also can use this option as a shortcut to send a workbook as an _____________.
General office
When you add comments, Excel automatically displays the name that appears in the Name box under __________ ___________ settings in the Excel Options dialog box. If you don't want to use a name, you can select it in the comment and press Delete.
enter reject
When you have saved your workbook and you want to delete a change, you can either _________ new data or ________ the change you made before saving.
hide
When you protect a worksheet, you can ______ any formulas that you do not want to be visible in the formula bar.
off
When you turn _____ change tracking, the workbook is no longer a shared workbook
shared workbook
When you turn on Track Changes, the workbook automatically becomes a _________ ______________.
browser
When you work in the ___________, you can change data, enter or edit formulas, and apply basic formatting to the spreadsheet. You can also work with others on the same workbook at the same time.
Same copy
With SkyDrive, If someone needs to make modifications, they do so in the ________ _______, with no need to merge multiple versions and copies of the document.
14
A password that uses ____ or more characters, however, is considered to be more secure.
does not
A shared workbook ________ support all Excel features
stop
Any unsaved changes will be lost when you _______ sharing and the history worksheet is deleted.
Yes
Are passwords case sensitive?
read only
Before you share a workbook with other users, you can use the Mark as Final command to make the document ______ ______ and discourage changes to the document.
TRUE
You can also require one password to open and view the workbook and a second password to modify workbook data.
keep accept
Depending on the options established when the workbook was created and shared, you can either _______ your change or _______ the change made by the other user.
Select the cells that contain the formulas you want to hide. Then, on the Protection tab of the Format Cells dialog box, select the Hidden check box
How to hide formulas you dont want to be visible in formula bar when you protect a worksheet
directly
If you click on an Excel workbook while in your SkyDrive.com account, the workbook opens ___________ in your browser.
Before
If you want to assign a password to a shared workbook, you must assign it _________ the workbook is shared.
255
Excel passwords can contain up to ____ letters, numbers, spaces, and symbols.
cannot
you can include merged cells, conditional formats, data validation, charts, and so on before a workbook is shared, but these features ___________ be added by those who edit a shared workbook.
30 advanced share workbook
By default, changes made in the workbook will be retained for ___ days. You can increase that time frame on the ____________ tab of the ________ ____________ dialog box
save
Changes become a part of the change history only when you ________.
accept reject
Changes must be saved before you can _________ or ________ them.
unshare lost
However, when you _________ a shared workbook, the change history is ______.
cannot
If you forget your password, Microsoft _________ retrieve it.
apply to an entire workbook
Passwords that ______ ____ ____ ________ _________ provide optimal security for your data.
link single copy
Saving a document in SkyDrive also makes it simple to share the document with others. You can send a _______ directly to them, rather than sending an attachment. This way, you preserve just a _________ ________ of the document
windows box
Selecting the ________ ___ on the Protect Structure and Windows dialog box prevents the user from changing the size and position of the windows when the workbook is opened.
close
Some email programs will not send a document as an attachment if the document is open on your computer. If you receive such a message, ________ the document, and click Send again.
not
The Mark as Final command is _______ a security feature. Anyone who opens a workbook that has been marked as final can edit the document by removing the Mark as Final status from the document by clicking the Edit Anyway button.
owner
The __________ (creator) of the workbook can use change-tracking functions to manage the data in a shared workbook.
prevent and share workbook
The __________ ____ ______ ______________ command prevents a user from disabling the Track Changes option.
RANDBETWEEN
The __________ formula generates a new random number each time a workbook is opened or modified
Protect and share workbook
The ___________ ______ ________ _____________ command provides the highest level of security because you can add a password.
Advanced before
The _____________ tab of the Share Workbook dialog box allows you to customize the shared use of the workbook. These options are normally set by the workbook author ________ the workbook is shared.
track changes
The ability to _______ ________ is especially helpful in a workbook that is shared and modified by multiple users.
email faxing printing
The most common ways to share Excel data are by sending workbooks through _______, by __________ workbooks, and by ____________ and distributing hard copies.
Sent to mail recipient
The option to send a worksheet as an email message is available only from the ________ ____ _______ ______________ command on the Quick Access Toolbar.
advanced
The options set on the _____________ tab of the Share Workbook dialog box determine how conflicts are resolved.
where
You can also click the Collapse Dialog button in the _________ box on the Select Changes to Accept or Reject dialog box and select the cells that contain changes. You can then accept or reject the changes in their entirety.
past conflicts
You can also display a list that shows _______ __________ have been resolved. These can be viewed on a separate worksheet that displays the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.
attatchment email message
You can email a workbook as an _____________ from Excel or from your email program. You can also send a worksheet as an _________ _____________ rather than as an attachment.
individually
You must remove each type of hidden data ____________. You can inspect the document again after you remove items.
same
Your workbooks look the _______ in the Web browser as they do in Excel.
track changes
_______ ________ determines whether a change history is kept and the length of time it is kept.
RAND
_______ does not require function arguments, so you cannot specify the number of digits you want in the number returned by a RAND formula
________ allows you to share a workbook by routing it to one user who can make changes or add comments and then route the workbook to the next user. Changes can then be incorporated into a final document
Protecting the structure
_________ ___ __________ of a workbook prevents users from viewing worksheets that you have hidden; inserting new worksheets; or moving, deleting, hiding, or changing the names of worksheets.
update changes
__________ ________ controls when changes made to the shared workbook are incorporated into the workbook.
Windows live skydrive
___________ ______ __________ is a virtual online storage area in the cloud where users are able to store, access, and share thousands of documents, photos, and Microsoft Office files. SkyDrive also can password-protect your files so you control who has access to them.
include in personal view
____________ ___ ___________ ______ enables each user who edits the workbook to see a personal view of the workbook.
conflicting changes between users
_____________ _________ ____________ ______ determines whose edits become part of the file if two or more people attempt to edit at the same time. The workbook owner's changes usually take precedence.
strong password
a _______ ____________is one that combines uppercase and lowercase letters, numbers, and symbols