…In this workbook called state sales data,…we've got four separate worksheets for different states.…And maybe we're going to be expanding…these worksheets, and we've decided it's going…to be better if we actually have four separate files, one for each state.…Now there are a couple of approaches as to how we might achieve this objective.…One approach could be, we can open a new…workbook, move the California sheet there and save that…workbook, open another new workbook, move Arizona there, do…the same thing with Oregon, same thing with Nevada.…
That would work.…Probably easier and faster, would be to simply save this file four times.…First naming it California, then Arizona, then Oregon, then Nevada.…Four separate files.…And in each file, what we would do…then, is simply delete the sheets we didn't need.…So, if we save this as California, we can then open that file…and make sure that we don't have the Arizona, Oregon and Nevada sheets.…We'll simply delete them.…
And similarly on the Arizona file, we'll get rid…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.