You have a sales report in Excel. You want to make sure no one accidentally changes the total sales numbers in column D, but they can still add new sales data in columns A to C. What is the best way to protect the data?
Think about which cells should be locked to prevent changes and which should remain editable.
Locking column D cells and then protecting the sheet prevents accidental edits to totals. Unlocking columns A to C allows users to enter new data. Protecting the workbook structure or hiding columns does not prevent editing specific cells.
You have a formula in cell E2: =SUM(A2:D2). The sheet is protected, and cell E2 is locked. What happens if a user tries to change the formula in E2?
Think about what locking a cell and protecting a sheet does to cell editing.
When a cell is locked and the sheet is protected, Excel prevents any changes to that cell, including editing formulas. Trying to edit shows an error message.
You want to allow users to enter only numbers between 1 and 100 in column B, but prevent them from changing the validation rules. Which combination of Excel features should you use?
Sheet protection prevents changes to validation rules. Consider which cells should be unlocked for data entry and locked elsewhere.
Sheet protection prevents modifications to data validation rules. Locking column B cells would block data entry, while unlocking them allows validated input. Option A locks other cells to prevent edits there, ensuring comprehensive protection.
A team shares an Excel workbook. The manager protects the sheet locking all formula cells but leaves input cells unlocked. After protection, some team members report they cannot enter data in certain cells. What is the most likely cause?
Think about how locking cells affects editing when the sheet is protected.
If input cells are locked before protecting the sheet, users cannot edit them. Only unlocked cells remain editable. Protecting workbook structure does not block cell edits. Forgotten password prevents unprotecting but does not block editing unlocked cells. Deleted formulas do not cause input cells to be uneditable.
Which statement best explains why protecting a sheet is more effective than protecting the workbook structure to prevent accidental data changes?
Think about what each protection type controls in Excel.
Sheet protection controls what users can do on a specific sheet, like editing locked cells or formatting. Workbook protection controls the structure of the workbook, such as adding or deleting sheets, but does not prevent editing cell contents.