Excel Expert Module 7

Which of the following can you prevent by protecting a worksheet's structure

Adding, deleting, or moving worksheets

Which of the following can you complete with a comment

All of the above (respond, resolve, make)

Which of the following are ways to control the sharing of your worksheet

Control access to the worksheet by using a password Use the Share option to share your work with others by using their email addresses.

Which of the following can you change within AutoRecover

Location where the autorecovered workbook is saved The type of file format that the workbook is saved in The time interval defining how often the workbook is saved Disabling AutoRecover for a workbook

You were working on a large Excel workbook that you haven't saved, and your device just stopped responding. How can you get your work back

Reopen Excel, and then use the AutoRecover task pane

Which of the following is a true statement about version history

You can restore an older version of a file

Which of the following statements are true when protecting a worksheet

You can specify the areas of the worksheet that users can access. you can create a password to access the worksheet.

Which of the following can you protect by using Excel

all the above (workbook, worksheet, range of cells)

1. Correctly categorize the processes listed below into one of the following two categories: Happens at a user-set time Is created each time a workbook is saved Prompts the recovery of unsaved work when a device stops responding or there is a power outage Can be used to compare versions .

autorecover version history autorecover version history

Which of the following methods can you use to create a comment

context menu, review tab

To share a worksheet with another user, you'll need to know the other person's

email address

List the following steps in the appropriate order for creating an AutoRecover setting

file options save set time interval

Place the following steps in the correct order to help protect specific areas of a worksheet

select cells to allow users to edit right click or access context menu select protection tab clear locked check box

Place the following steps in the correct order to protect a worksheet

select file select info select protect workbook select encrypt with password

Which of the following can you use comments for in Excel

to start a conversation about data within cell to add information to data contained within a cell

Someone has altered the work in your workbook. If you use the...option, you can restore your original work

version history