Datasheet

11
Chapter 1: Getting Familiar with the Excel 2010 Interface
such as saving and printing. If you prefer, you can open this view and access the menu
by pressing Alt+F (F for File) instead of clicking the File menu.
When you select any of the major options on this menu — Info, Recent, New, Print, Save
& Send, or Help — panels appear that bring together further related and commonly
used menu options on the left side along with pertinent information and, in the case, of
the Info and Print options, document previews, on the right side.
Before you attempt the exercises in this chapter, you may want to play the Using the
Excel 2010 Ribbon and Backstage.exe demo located in the Excel Feature Demo folder
on your workbook CD-ROM. This video demonstrates selecting commands from the File
menu as well as on the Ribbon and Quick Access toolbar.
Exercise 1-1: Opening the Backstage View and Selecting Its Menu Commands
In this exercise, you get familiar with the new Excel Backstage View and the commands
on its File menu as you practice opening the Backstage View and selecting some of its
menu commands. Make sure that Excel 2010 is running and an empty Sheet1 worksheet
is active on your computer monitor (see Chapter 2 if you need information on launching
Excel).
1. Click the File menu to switch to the Excel Backstage View and display the list of
commands (Info through Exit) on the left side of this screen.
Keep in mind that when you switch to the Backstage View when no workbook is
open for editing in Excel 2010, the program automatically selects the Recent menu
command that displays a Recent Workbooks pane on the left with a list of recently
opened workbook files and a Recent Places pane on the right with a list of file
folders recently opened. When you switch to the Backstage View when a workbook
file is open for editing, Excel selects the Info option at the top of the menu instead,
displaying a panel with a thumbnail of the current worksheet and a list of properties
describing aspects of the file.
2. Click the Info option on the menu.
Note that an Information about Book1 panel now appears attached to the
immediate right of the Info option and that all of the suboptions, Save through
Close above Info, are indented as a group (see Figure 1-2).
3. Now, highlight and click the Save As command to select it.
Excel opens the Save As dialog box in the regular worksheet view where you can
modify the name, location, and type of Excel workbook file before saving a copy of it.
4. Press the Esc (Escape) key on your keyboard to close the Save As dialog box.
5. Press Alt+F to open the Backstage View with its File menu again, this time from the
keyboard.
This time, small letters appear on each command in the Backstage View menu.
These are the access keys that you can type to select a menu option rather than
clicking its name or button.
6. Type D to select the Save & Send option and display the Save & Send panel, which
contains a number of options for sharing workbook files with coworkers and clients.
7. Click the File menu at the top of the menu, immediately above the Save option.
05_489604-ch01.indd 1105_489604-ch01.indd 11 7/29/10 11:25 PM7/29/10 11:25 PM