DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Encrypt workbook with a password
|
|
|
Protected Range with Password
|
|
|
Protect Current sheet
|
|
|
Protected Workbook Structure
|
Detailed explanation-1: -Older versions of Excel employed weak encryption that was easily overcome. Microsoft Office now uses the AES-256 encryption algorithm which is generally regarded as statistically unbreakable in a reasonable amount of time.
Detailed explanation-2: -If you don’t want others to open your file: You can encrypt the Excel file, which is the most common technique used. This basically means you lock it with a password and nobody except you can open it.
Detailed explanation-3: -But storing privileged account passwords and credentials in an Excel spreadsheet poses a serious security risk. Excel was never intended to be a password manager, so there’s no chance it’s ever going to be the best way to store passwords, even if it’s password-protected.