Excel Question

Your assignment: Practice various techniques to control access to spreadsheets.

1. Download the spreadsheet template for this assignment.

2. Perform the following tasks
a. Protect the entire workbook so that it requires a Password to open it
 Use the Workbook Password “AsUsUnD3v1L!”
(REMEMBER TO ADD “!” TO THE END OF THE PASSWORD ABOVE)
b. Password protect sheet 1
 Use the Worksheet Password “#Dr0wSsaP#”
(REMEMBER TO ADD “#” TO THE END OF THE PASSWORD ABOVE)
c. Hide sheet 2
d. Hide the row for “New hires” in sheet 1
e. Lock column I
f. Lock cells F11, F21, and F26

3. Add the following information to cell D1 in sheet 2: “This information is top secret” but do so in a
manner that although column D is visible, the newly typed phrase is not. No other changes to sheet 2
are to be made.

4. Add a new sheet (sheet 3) and label it “Explanation”. In the “Explanation” worksheet, write a brief
explanation of how you did each of the tasks 2a2f and step 3 above.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.