Datasheet

8 Part 1: Getting to Know Excel 2010
Keys Action
Ctrl+Backspace Scrolls the screen to display the active cell
Up arrow* Scrolls the screen one row up (active cell doesn’t change)
Down arrow* Scrolls the screen one row down (active cell doesn’t change)
Left arrow* Scrolls the screen one column left (active cell doesn’t change)
Right arrow* Scrolls the screen one column right (active cell doesn’t change)
* With Scroll Lock on
Introducing the Ribbon
Excel comes with a user interface called the Ribbon, which consists of a series of
horizontal tabs, each containing a variety of commands grouped according to
function (see Figure 1-3). Most features in Excel 2010 are available through the
commands on the Ribbon tabs.
Figure 1-3
Contextual tab headerHome tab
Dialog launcherSplit button Contextual tabs
Dissecting the parts of the Ribbon
The commands on the Ribbon are accessed through a variety of controls. Here’s
a list of the various types of controls and other parts that make up the Ribbon:
✓ Button: This is the most common type of control. Most buttons on the
Ribbon (except the formatting ones) have descriptive text associated with
them, so you don’t need to be a Mensa expert to figure out what a button
represents. The most frequently used commands on each Ribbon tab have
larger buttons.
Most buttons execute commands directly when you click them. However,
some buttons have an embedded downward-pointing arrow, and others
have an attached downward-pointing arrow. Clicking a button with an
embedded arrow displays a menu or gallery. For a button with an attached
03_527559-ch01.indd 803_527559-ch01.indd 8 4/1/10 6:59 PM4/1/10 6:59 PM