|
INTERVIEW QUESTIONS
MICROSOFT OFFICE
MICROSOFT EXCEL
DETAILS
Question: If I protect my worksheet with a password, is it really secure?
Answer:
No. Don't confuse protection with security. Worksheet protection is not a security feature. Fact is, Excel uses a very simple encryption system for worksheet protection. When you protect a worksheet with a password, that password -- as well as many others -- can be used to unprotect the worksheet. Consequently, it's very easy to "break" a password-protected worksheet.
Worksheet protection is not really intended to prevent people from accessing data in a worksheet. If someone really wants to get your data, they can. If you really need to keep your data secure, Excel is not the best platform to use.
|
|
|
Category |
Microsoft Excel Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8663 users |
Added on |
9/24/2012 5:06:58 AM |
Views |
69816 |
Rate it! |
|
|
Question:
If I protect my worksheet with a password, is it really secure?
Answer:
No. Don't confuse protection with security. Worksheet protection is not a security feature. Fact is, Excel uses a very simple encryption system for worksheet protection. When you protect a worksheet with a password, that password -- as well as many others -- can be used to unprotect the worksheet. Consequently, it's very easy to "break" a password-protected worksheet.
Worksheet protection is not really intended to prevent people from accessing data in a worksheet. If someone really wants to get your data, they can. If you really need to keep your data secure, Excel is not the best platform to use. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Can I set things up so my VBA macro can make changes to Locked cells on a protected sheet?
|
View Answer
|
|
How can I find out more about the new protection options available in Excel 2002?
|
View Answer
|
|
Can I lock cells such that only specific users can modify them?
|
View Answer
|
|
Why aren't these options available in earlier versions of Excel?
|
View Answer
|
|
Why aren't these options available in earlier versions of Excel?
|
View Answer
|
|
Why aren't these options available in earlier versions of Excel?
|
View Answer
|
|
How is worksheet protection different in Excel 2002?
|
View Answer
|
|
I protected my worksheet, but now I can't even do simple things like sorting a range. What's wrong?
|
View Answer
|
|
I made some cells hidden and then protected the worksheet. But I can still see them. What's wrong?
|
View Answer
|
|
How do I unlock a cell?
|
View Answer
|
|
I tried the procedure outlined above, and it doesn't let me change any cells! I only want to protect some of the cells, not all of them.
|
View Answer
|
|
How do I protect a worksheet?
|
View Answer
|
|
How can I print the workbook's full path and filename in a page header?
|
View Answer
|
|
Is it possible to change the color and font of the sheet tabs?
|
View Answer
|
|
How can I increase the number of rows in a worksheet?
|
View Answer
|
|
How can I increase the number of columns in a worksheet?
|
View Answer
|
|
How can I add a drop-down list to a cell so the user can choose a value from the list?
|
View Answer
|
|
Is there a utility that will convert my Excel application into a stand-alone EXE file?
|
View Answer
|
|
Is there a way to automatically convert 1-2-3 or Quattro Pro macros to VBA macros?
|
View Answer
|
|
Is it possible to call a VBA procedure from an Excel 4.0 XLM macro?
|
View Answer
|