Question

Can you insert graphs too? Excel offers a variety of tools to protect/secure valuable personal and...

Can you insert graphs too?

Excel offers a variety of tools to protect/secure valuable personal and company data such as marking the file as final, encrypting the file with a password, restricting permissions, and adding digital signatures. Please inform yourself of the various security levels that these controls offer and discuss with your peers.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Excel gives you the ability to protect your work, whether it’s to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just protecting a worksheet so you don’t inadvertently delete any formulas

  • To control the level of access users should have to an Excel file, use file-level protection. Let’s say you have a weekly status report of your team members in an Excel file. You don’t want anyone outside your team to be even able to open the file. There are two options available:

(i)If you don’t want others to open your file:

You can encrypt the Excel file, which is the most common technique used.

(ii)If you want to enable Read-only or editing access to different users:

Maybe, you want the managers in your team to be able to edit the weekly status report, but team members should only have Read-only access.

  • To control how users should work with worksheets inside a your workbook’s structure, use workbook-level protection.

Let’s say your status report workbook has multiple worksheets, and each worksheet is named after a team member. You want to make sure each team member can add data to their own worksheet, but not be able to modify any of the worksheets in the workbook, whether it be adding a new worksheet, or moving worksheets around within the workbook.

  • To control how users should work within an individual worksheet, use worksheet-level protection.

Let’s say each worksheet in your status report workbook contains data that is common to all worksheets, like header rows or a specific report layout, and you really don’t want anyone to change it. By protecting your worksheet, you can specify that users can only perform specific functions in a sheet. For example, you can   give users the ability to enter data, but keep them from deleting rows or columns, or only insert hyperlinks or sort data.

Add a comment
Know the answer?
Add Answer to:
Can you insert graphs too? Excel offers a variety of tools to protect/secure valuable personal and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • CASE 8 Unlocking the Secrets of the Apple iPhone in the Name of access the male...

    CASE 8 Unlocking the Secrets of the Apple iPhone in the Name of access the male San Bernardino suspect's iPhone 5c. Cook stated: Antiterrorism We are challenging the FBI's demands with the deepes respect for American democracy and a love of our country. We believe it would be in the best interest of everyone to step back and consider the implications While we believe the FBI's intentions are good, if would be wrong for the w e nt to force...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT