Question

Questions: 1,2,5 can have multiple answers.
Please make sure of the answers.

1) You may use the scenarios feature to

change the values of various cells

save the changed values

compare differing scenarios

2) Before you can use Excel's Solver you need

objective cells

changing variable cells

constraints

3) When sharing a workbook protect it with a password post its password on your FaceBook page never use a password none of the above

4) If you forget your workbook's password you can

call Microsoft and they will give you the default password

open it without the password as long as you are using the same computer

change the password to a new one that you can remember

5) You can use a password to protect a workbook from

being opened

being modified

being saved

there is nothing that can be done!

Answer 1

Answer)

1) You may use the scenarios feature to
    change the values of various cells
    save the changed values
    compare differing scenarios
  
The Excel Scenario feature is mainly used to compare the different scenarios. It lets you substitute input values for multiple cells, which you can view the results of different values at the same time comparing the different scenarios using the values.

Answer) c) compare differing scenarios
  
  
   2) Before you can use Excel's Solver you need
    objective cells
    changing variable cells
  
Excel's Solver needs objective cells, as solver works to find optimal value for formula in one cell.
Answer) a) objective cells

3) constraints
   
When sharing a workbook
    protect it with a password
    post its password on your FaceBook page
    never use a password
    none of the above
  
   Answer)
   It's a good idea to protect it with a password, when you're sharing a workbook for the protection of the data inside it.
   Answer) protect it with a password