Excel Module 04 Study Guide Rated A+

Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements. To do so, she can first unlock editable cells, then click Review tab > Protect Sheet > Allow all users of this worksheet to list > Select the elements you want people to be able to change > OK. {Ans: True}Kai wants to hide a worksheet with a password to prevent other users from viewing it. To do so, he can Click Review > Protect Workbook > Enter a password in the Password box > OK. He can then retype the password to confirm it, and then click OK. {Ans: True}A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so? {Ans: =ROUND(A5,2)}One can create a one-variable data table in Excel to test a series of values for a single input cell and see the influence of these values on the result of a related formula. {Ans: True}To format a cell range so that values between 100 and 500 appear in red, which of the following can you use? {Ans: Highlight