11. Because the workbook contains sensitive data, protect the workbook as follows: a. Protect the workbook structure using Oscar as the password. b. Mark the workbook as final.
Added by Michael P.
Step 1
Let's think step by step. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 98 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
1. Enable the Japanese language for authoring and proofing. 2. On the P and L sheet, for cells D3:D14, only allow values between -10,000,000.00 and 100,000,000.00. Include a warning message if an invalid value is entered that displays "Value out of expected range. Contact SVP of Finance." 3. On the P and L sheet, prevent changes to cells A3:C14 for finance only. Require the password "FinOnly" to modify the range. 4. Protect the workbook structure with the "allowchanges" password. 5. On the Gross Profit sheet, forecast Sales for the next two years using a linear series with a growth rate of $125,000 per quarter. 6. On the Cycle Count sheet, audit results were combined but have duplicates. Use the appropriate command to remove duplicate listings.
Akash M.
outline three ways to protect workbook in excel
Haricharan G.
22. The Tools > Protect Document > Sheet option can be used to: a) share the sheet b) protect the sheet c) hide the sheet.
Joy D.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD