EXCEL ch 9

locking cells

- by default, a cell has the property of being locked - by unchecking the 'locked' field, we can unlock a cell - we can protect a blank cell such that no one can enter data in that cell

protecting data

- can lock and/or hide ranges

hide formula in a cell

- click on the 'hidden' option in the protection tab (in the 'format cells' command)

"save as" dialog box leads us to options to:

- create a password - make the file read only - make a back up copy

the 'password protection feature' can be applied to which of the following

- either worksheets or workbooks

the dialog box

- gives us an option to create a password to open and/or to modify - also gives is the option to make a file read only and to make a back up copy of the file "back up of _____"

to protect a workbook

- keyboard: ALT-F, a - mouse: File, Save as then click tools, general options , gives us the password option

to protect a worksheet

- keyboard: ALT-H, o, p - mouse: HOME ribbon, cells group, format, protect sheet - is a worksheet feature, each worksheet will have to be protected separately

to lock/unlock a worksheet

- keyboard: CTRL+1, p, ALT+I - mouse: HOME ribbon, cells group, format, format cells - can be password protected

in excel we can

- lock a cell - protect a worksheet - protect the entire workbook

protecting a cell is a two step process

- lock the cell or cells - protect the worksheet

to prevent modification of selected cells in a worksheet, you will need to:

- lock the selected cells and then protect the worksheet

read only

- means that we cannot make changes to the file - can override the read only by clicking no

protecting a workbook

- requiring a password to open the workbook - requiring a password to modify the workbook

which of the following is FALSE?

- using a password provides a high level of security in protecting a worksheet