…If you've opened a work book like this one, it's called sample, that has multiple…worksheets in it, first instinct might be…to start clicking on the different sheet tabs.…Not a bad idea.…But if this is a work book that you've never seen,…or one that you have not seen in a long time.…It's likely to be a little bit faster to absorb what this work book is about.…By pointing to the two arrows in the lower left corner.…Now if you right click with in the two arrow location there, right…click, you will get a list it's…called activate, within the activate dialogue box.…
Of all the worksheets that are here, if there are more than 20.…The scroll bar on the right will become active and…you can scroll up and down to see the additional ones.…The left to right order that you see at the bottom of…the screen translates into a top down order as we see it here.…And so we can see the first few sheet names here.…If this is a work book that we've seen before maybe we remember that the formulas…tab has an interesting worksheet on it so…
- 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.