Multiple Choice
As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year.
-In order for Seth to allow others to enter data into some of the cells in the worksheet but not others, he should ____.
A) unlock the cells he wants users to access and then protect the worksheet
B) protect the worksheet and then unlock the cells he wants users to access
C) name ranges and click "allow data entry" in the Data Validation dialog box
D) none of the above
Correct Answer:

Verified
Correct Answer:
Verified
Q119: You can immediately fix the #### error
Q120: You can use up to three levels
Q121: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Elianna has
Q122: If you set up the validation rule
Q123: The data validation tool restricts data being
Q125: For optimal password security, Microsoft recommends that
Q126: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q127: The Excel formula auditing tools help you
Q128: In VBA, comments appear in green and
Q129: One way to make a workbook easier