Excel Lesson 11

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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

Email

________ 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


Kaugnay na mga set ng pag-aaral

Chapter 2: Physical Quantities and Measurements

View Set

Pavement Markings & Traffic Signals (Chapter 5)

View Set

AUD - CPA Exam - Accounting and Review Services

View Set

Knee: AP Oblique Projection Lateral rotation

View Set

Unit 1 -- Entrepreneurial Search

View Set

Year 1 Semester 1 Final - WCP AM

View Set