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