ITLN23B_MIDTERM (LESSON 4)

If you want to share a workbook with people who are using a different version of Excel, you can change the file type to a different version, or check the workbook for compatibility with earlier versions. (T/F)

TRUE

It can be determined mathematically how long it takes to crack various passwords (T/F)

TRUE

The workbooks that you combine must have been created from the same shared workbook (T/F)

TRUE

if you forget the password, you will be locked out too (T/F)

TRUE

you can use Excel's header and footer options to add predefined header and footer information, such as the date and time, or the name of the last person that accessed or edited the file. You can also insert elements such as page numbers and the file name (T/F)

TRUE

ENABLE AUTO RECOVER (FILE>OPTIONS>SAVE)

To help protect your data

PROTECT THE WORKBOOK

To prevent users from inserting, deleting, and renaming worksheets

To allow changes to some cells and not others, ____________________________

UNLOCK THE CELLS THAT CAN BE CHANGED

TO PREVENT USERS TO MAKE AN ALTERATION OR CHANGE TO THE LIST

You can set a password that allows only those who know the password to modify a workbook

TRACKING CHANGES

allows other people to review the changes and comments that you have made

TRACKING CHANGES

allows you to see the modifications that have been made to a worksheet, including formatting changes and inserted or deleted text, numbers, rows, and columns

LOCKED CELL

cannot be edited or deleted

MARK AS FINAL

command to make the workbook read-only and prevent any further changes

PASSWORD THAT USES A RANDOM SET OF CHARACTERS

password that is more difficult to decipher than one that is not random

REVIEW TAB>TRACK CHANGES>ACCEPT/REJECT CHANGES

steps to accept/reject changes

REVIEW>COMMENTS>NEW COMMENT

steps to add a comment to worksheet

INSERT>TEXT>HEADER & FOOTER>HEADER & FOOTER TOOLS>DESIGN>HEADER & FOOTER ELEMENTS> CURRENT DATE

steps to add a date in the header

INSERT>TEXT>HEADER & FOOTER>HEADER & FOOTER TOOLS>DESIGN>HEADER & FOOTER ELEMENTS>NUMBER OF PAGES

steps to add a date in the number of pages

REVIEW>CHANGES>ALLOW USERS TO EDIT RANGES

steps to allow specific users to edit cell ranges in a protected worksheet or workbook

FILE>INFO>PROTECT WORKBOOK>ADD A DIGITAL SIGNATURE

steps to attach/add a digital signature

REVIEW>CHANGES>SHARE WORKBOOK>UNCHECK "ALLOW CHANGES..BOX>OK>YES>PROTECT WORKBOOK>UNCHECK THE "PROTECT STRUCTURE AND WINDOWS" OPTION

steps to copy or move a worksheet (part 1)

HOME>CELLS>FORMAT>ORGANIZE SHEETS>MOVE/COPY SHEET

steps to copy or move a worksheet (part 2)

REVIEW CHANGES>SHARE WORKBOOK>CHECK THE ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME BOX>OK>OK

steps to create a Share Workbook

REVIEW>COMMENTS>DELETE COMMENT

steps to delete a comment to worksheet

FILE>INFO>PROTECT WORKBOOK>MARK AS FINAL

steps to mark a document as final

FILE>OPTIONS>QUICK ACCESS TOOLBAR>CHOOSE COMMANDS FROM>ALL COMMANDS>COMPARE AND MERGE WORKBOOKS>ADD

steps to merge workbooks

FILE>SAVE AS>TOOLS>GENERAL OPTIONS>DELETE THE KEYED WORD IN PASSWORD TO OPEN BOX> CLICK PASSWORD TO MODIFY BOX> KEY A WORD>OK>SAVE>YES

steps to set a password to modify a workbook

FILE> SAVE AS> TOOLS DROP-DOWN ARROW> GENERAL OPTIONS> PASSWORD TO OPEN>KEY A WORD>OK>SAVE>YES

steps to set a password to open a workbook

IF YOU ACCEPT THE CHANGE

the cell's content will reflect the update

IF YOU REJECT OR REFUSE TO ACCEPT A CHANGE

the cell's original value will be restored

MICROSOFT EXCEL 2010

this version of MS Excel allows you to PROTECT WORKBOOKS USING THE RIBBON OR THE BACKSTAGE VIEW

SHARE THE WORKBOOK

to allow multiple users can have access to this file at the same time (can add, edit, delete information from their own computer)

MERGE/COMBINE WORKBOOK VERSIONS

to create the final workbook

COPY A WORKSHEET

to distribute, or give out, a new worksheet

ATTACH A DIGITAL SIGNATURE

to identify yourself as the source, or origin, of the workbook

INSERT A COMMENT

to make a suggestion or ask questions about the data

CTRL + PAGE UP

to move to the previous worksheet

PROTECT CELLS CONTAINING FORMULAS

to prevent users not inadvertently key values in those cells

REVIEW CHANGES>PROTECT> WORKBOOK> CHECK THE STRUCTURE CHECKBOX

to protect workbook

FILE>INFO>PROTECT WORKBOOK

to protect workbook using BACKSTAGE VIEW

FORMAT>PROTECTION>PROTECT SHEET> CLICK OK

to protect worksheet

REVIEW>COMMENTS>SHOW ALL COMMENTS

to specify whether or not balloons are shown that contain deletions and comments

REVIEW>CHANGES>TRACK CHANGES>HIGHLIGHT CHANGES>CHECK "TRACK CHANGES WHILE EDITING" BOX>UNCHECK "WHEN

to track changes while editing

HOME>CELLS>FORMAT>PROTECTION>FORMAT CELLS>PROTECTION TAB> UNCHECK THE LOCKED BOX

to unlock cells

When the pointer is positioned over a changed cell, a window appears containing the:

-REVIEWER'S NAME -DATE -CELL MODIFICATION

Documents marked as final in Office ____ and _____ WILL NOT BE read-only if they are opened in an earlier version of Office

2007 , 2010

After the changes are made in a document, you can choose to ________ each tracked change

ACCEPT OR REJECT

Password appears as ____________ for security reasons

BLACK DOTS

Passwords are __________

CASE SENSITIVE

When the document is marked as final, keying, editing commands, and proofing marks are _________

DISABLED

if your password has uppercase, lowercase, or a combination of uppercase and lowercase letters, you must _____________

KEY IT THE SAME WAY EVERYTIME

Adding protection to a worksheet will ______ all cells by default

LOCK

If a workbook contains sensitive material such as salaries or bank statements, you can set a __________ so no user can open the file without it

PASSWORD

You can also save workbooks as ____________ files before sharing them with other users so that they cannot be modified

PDF or XPS

Comments will exhibit a _______ in the __________ of a cell or range of cells

RED TRIANGLE , UPPER RIGHT-HAND CORNER

Record passwords in a __________

SECURE LOCATION

TRACK CHANGE

used to mark edits made

EXCEL'S HEADER & FOOTER OPTIONS

used to quickly provide useful information in your worksheets when you are printing a worksheet or workbook, or sharing data with others

HIGHLIGHTED CHANGES ON-SCREEN

will exhibit a colored cell border with a small triangle inside the upper-left corner

When you protect a workbook or worksheets, __________________________

you prevent others from making changes to it