Data Analysis with Microsoft Excel: Updated for Office 2007

8 Excel

The menu commands below the Offi ce button are used to set the proper-

ties of your Excel application and entire Excel documents. If you want to

work with the contents of a document you work with the commands found

on the Excel ribbon.

Each of the tabs on the Excel ribbon contains a rich collection of icons and

buttons providing one-click access to Excel commands. Table 1-2 describes

the different tabs available on the ribbon.

Note that this list of tabs and groups will change on the basis of how Excel

is being used by you. Excel, like other Offi ce 2007 products, is designed to

show only the commands which are pertinent to your current task.

Office button keyboard shortcut

menu commands

Figure 1-6

Accessing

commands

from the

Office button

Table 1-2 Excel Ribbon Tabs

Ribbon tab Description Ribbon Groups
Home Used to format the contents of worksheet
cells

Clipboard, Font, Alignment,
Number, Styles, Cells, Editing
Insert Used to insert objects into an Excel
workbook

Tables, Illustrations, Charts,
Links, Text
Page
Layout

Used to format the printed version of the

Excel workbook and to control how each

worksheet appears in the Excel window

Themes, Page Setup, Scale to

Fit, Sheet Options, Arrange

(continued)