Chapter 11 Quiz

Workbooks containing _____ cannot be shared. -10 columns or more of data -tables -formatting -fixed cells

tables Formatting isn't a blocker for sharing a workbook.

What does it mean if you are sharing a workbook and you keep the following default option? Ask me which changes win -If another user makes a change to a workbook, Excel asks whether the user is your superior. -If another user makes a change to a workbook, Excel asks whether the change is more appropriate than the data you entered. -If another user makes a change to a workbook you just changed, Excel asks whether you understand that the new data is larger than your data. -If another user makes a change to a workbook you just changed, Excel asks whether you want to retain that user's change.

If another user makes a change to a workbook you just changed, Excel asks whether you want to retain that user's change. When sharing a workbook, users can overwrite each other's work; however, settings can determine which users have overwriting authority.

You do not want anyone to make changes in column G, and you do not want column H to be visible. What should you do?

Lock column G, hide column H, and then select Protect Sheet on the Review tab. You apply the Lock Column option so it is read-only, and you can hide columns by changing the setting to "Hide."

Thomas wants to set up his worksheet with a password. Which option would he use for allowing others to open and edit his workbook? -Password to close -Password to modify -Password to open -Read-only recommended

Password to open Setting this will allow certain people to open and edit your file.

Carol needs to protect the structure of her Excel file. Which feature should she use? -Protect Workbook -Protect Worksheet -Insert Password -Hide

Protect Workbook This feature will keep others from making structural changes to your workbook.

Rafael thought he had enough security on his worksheet by locking cells, but someone was still able to access the data in the worksheet. What did Rafael forget to do? -Protect the entire workbook. -Lock the columns and rows needed. -Hide data. -Rename the file.

Protect the entire workbook. Locking or unlocking cells in a worksheet does not have any meaningful effect until you protect the overall worksheet.

You are setting protections for a workbook under Save As > Tools > General Options. If you enter a password into the Password to open option but not in the Password to modify option, what does this mean for other users? -Users you give the password to can open the workbook with that password, but they will not be able to modify the workbook. -Any user can modify the workbook, but only users you give the password to can open the workbook with that password. -Users you give the password to can open the workbook with that password, and any user who can open the workbook can also modify it. -Any user who has the password will use it to open the workbook, and then use a system password to modify the workbook.

Users you give the password to can open the workbook with that password, and any user who can open the workbook can also modify it. You can specify that either the file is read-only or it is fully editable.

In Excel 2016, which type of workbook do you have to use to enable Track Changes? -a protected workbook -a shared workbook -a single-user workbook -a multi sheet workbook

a shared workbook A shared workbook is used to track changes.