Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 1 Getting Started with Excel 7

Running Excel Commands

You can run an Excel command either by clicking the icons found on the

Excel ribbon or by clicking the Offi ce button and then clicking one of the

commands from the menu that appears. Figure 1-6 shows how you would

open a file using the Open command available on the menu within the

Offi ce button. Note that some of the commands have keyboard shortcuts—

key combinations that run a command or macro. For example, pressing the

CTRL and keys simultaneously will also run the Open command.

Excel ribbon A toolbar containing Excel commands broken down into
different topical tabs
Formula bar Displays the formula or value entered into the currently
selected cell
Horizontal scroll bar Used to scroll through the contents of the worksheet in a
horizontal direction
Name box Displays the name or reference of the currently selected
object or cell
Offi ce button Displays a menu of commands related to the operation and
confi guration of Excel and Excel documents
Ribbon tab A tab containing Excel command buttons for a particular
topical area
Row headings Organizes cells into numeric rows
Sheet tabs Click to display individual worksheets
Status bar Displays messages about current Excel operations
Tab group A group of command buttons within a ribbon tab containing
commands focused on the same set of tasks
Title bar Displays the name of the application and the current Excel
document
Vertical scroll bar Used to scroll through the contents of the worksheet in a
vertical direction
Worksheet A collection of cells laid out in a grid where each cell can
contain a single text or numeric entry
Zoom controls Controls used to increase or decrease the magnifi cation
applied to the worksheet