…In this work book called Consolidation, we've got…four sheets representing different states, and we're tabulating…sales by product type, and by, for want…of a better term, sales outlet or sales method.…So ElectroCity for example is a retail store.…We've got online sales, this is another retailer.…We've got a wholesale method also.…But notice what happens when we click on Arizona.…Instead of seeing tables, lamps and desks, on the…Arizona sheet, we're seeing tables, desks, chairs and cabinets.…
And a few additional entries here in column A.…And over to Nevada, we see some of the things…we've seen already, and some of these we've seen too.…And then in California, we're seeing quite a few more entries in both cases.…So it varies, and yet we're seeing the same terms at different times.…So these worksheets are not identical, and yet what we'd…like to be able to do is to tabulate the data.…Now I've color coded them with yellow backgrounds to make…it easy to recognize what it is we're trying to tabulate.…So the question is, how do we…
- 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.