Theory
Emailing the confidential file
Aryan's dashboard holds Meera's confidential margins and months of careful formulas. He needs to email it to an accountant, but worries: what if someone opens it who should not? What if the accountant accidentally overwrites a formula or deletes a sheet?
These are three different threats, and Excel has a different lock for each. Using the wrong one leaves a gap.
Security is layered: guard the cells, guard the tabs, or guard the whole file. This closing lesson sorts the three levels, extending the protection you met in BCA105. Match the lock to the threat.
Theory
Drawer lock, room lock, building lock
Security has levels. A drawer lock protects specific contents (individual cells). A room lock stops rearranging the furniture (adding/deleting sheets). A building lock (the main gate) stops anyone entering at all (opening the file). You choose based on the threat: keep a colleague from editing one drawer, or keep strangers out of the building entirely. Locking the drawer does nothing if the building door is wide open, and vice versa.
At a glance
The three protection levels
| Level | Protects | Stops |
|---|---|---|
| Protect Sheet | Cells within a sheet | Editing locked cells/formulas |
| Protect Workbook | The tab structure | Adding/deleting/renaming sheets |
| Encrypt with Password | The whole file | Opening the file at all |
Theory
The three levels, precisely
- Protect Sheet (Review tab): locks cells. Remember the BCA105 two-step, all cells are locked by default, so unlock the editable ones first, then Protect Sheet, so formulas stay read-only while data entry is allowed.
- Protect Workbook (Structure): locks the tabs, no adding, deleting, renaming, moving or hiding sheets.
- Encrypt with Password (File > Info > Protect Workbook > Encrypt with Password): encrypts the whole file so it cannot even be opened without the password. This is the strong one, real encryption.
Three threats, three locks. Aryan uses all three for his confidential file.
Quiz
Aryan wants to ensure NOBODY can even open his confidential file without a password. Which protection does he need?
- Encrypt with Password (file-level), the only one that stops the file being opened
- Protect Sheet, which locks the cells
- Protect Workbook, which locks the tabs
- Hiding the sheet
Show the answer
Encrypt with Password (file-level), the only one that stops the file being opened
Only Encrypt with Password (file-level) stops the workbook from being opened at all, it genuinely encrypts the file. Protect Sheet (cells) and Protect Workbook (tabs) work inside an already-open file and do not prevent opening it. Matching the threat 'stop it being opened' to file encryption, versus 'stop edits inside' to sheet/workbook protection, is the core exam distinction.
Think first
Three locks for three threats
Aryan's threats: (a) the accountant might edit a formula; (b) the accountant might delete the summary tab; (c) a stranger might open the emailed file. Match each threat to the right protection.
Show the answer
(a) Edit a formula -> Protect Sheet (lock the formula cells, allow only data entry). (b) Delete a tab -> Protect Workbook (structure) (lock the tabs). (c) Stranger opens the file -> Encrypt with Password (file-level, stops opening). Three distinct threats, three distinct locks, and Aryan applies all three together for full protection. Using only one leaves the other two gaps open, which is exactly what exam scenarios test.
Watch out
Where marks leak
Confusing the three levels: Protect Sheet (cells), Protect Workbook (tabs/structure), Encrypt with Password (opening the file). Thinking Protect Sheet stops the file being opened, it does not; only encryption does. Forgetting the BCA105 lock-then-protect two-step for cells. And a real caution: a forgotten encrypt-password is generally unrecoverable, so record it safely. Match the lock to the threat, and name which one blocks opening.
Formula
You have mastered a professional tool
You have gone from the Ribbon to references, VLOOKUP, pivots, dashboards, macros, VBA, Power Query, Power Pivot, and now security, the full arc of a serious Excel professional. Aryan can now analyse the whole shop chain, automate the monthly grind, and keep it safe. 'Advanced Excel' on a resume, backed by real skill, opens doors in finance, analytics, and every office job. You have finished BCA106-01. Well done.
Summary
Key takeaways
- Excel security is layered: match the lock to the threat.
- Protect Sheet locks CELLS within a sheet (lock-then-protect, from BCA105) to guard formulas.
- Protect Workbook (structure) locks the TABS: no adding, deleting, renaming or hiding sheets.
- Encrypt with Password locks the WHOLE FILE: it cannot even be opened without the password (the only level that does this).
- A forgotten encryption password is generally unrecoverable, record it safely.
- Memory hook: drawer lock (cells), room lock (tabs), building lock (opening the file).