[go: up one dir, main page]
Scribd
Upload
168 views3 pages

Excel 2007 Screen Parts

The Excel 2007 screen contains several key areas including the Office Button, Ribbon, Name Box, Sheet Tabs, and Quick Access Toolbar. The Ribbon replaces menus and toolbars and contains tabs and groups of command buttons. Worksheets can be switched by clicking sheet tabs at the bottom and contain rows, columns, and an active cell to enter data.

Uploaded by

manket59
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
168 views3 pages

Excel 2007 Screen Parts

The Excel 2007 screen contains several key areas including the Office Button, Ribbon, Name Box, Sheet Tabs, and Quick Access Toolbar. The Ribbon replaces menus and toolbars and contains tabs and groups of command buttons. Worksheets can be switched by clicking sheet tabs at the bottom and contain rows, columns, and an active cell to enter data.

Uploaded by

manket59
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Parts of the Excel 2007 Screen

1. Office Button – Click the Office Button to find a drop down menu containing options, such as: open, save, and
print. Also shows previously opened files, which you may choose to “pin” them to make them “permanent” choices.

2. Ribbon – The Ribbon is the strip of buttons and icons located above the work area in Word 2007. The Ribbon
replaces the menus and toolbars found in earlier versions of Word. Each ribbon contains groups of command
buttons with common purpose. Each ribbon contains 7 tabs.
3. Name Box – Tells which cell is active. You may also type a cell reference (e.g., Q64) and hit enter to move your
active cell and screen to Q64.

4. Column Label – Columns run vertically on a worksheet and each one is identified by a letter. There are 18,412
columns.

5. Row Label – Rows run horizontally in a worksheet and are identified by a number. There are 1,048,576 rows.

6. Active Cell – Cell in which you can type – intersection of a row and a column. In each cell over 32,000 characters
can be entered.

7. Sheet Tab – Each workbook starts with 3 worksheets. You can switch between worksheets by clicking on the sheet
tab at the bottom of the screen. Additional changes to the tab (e.g., naming, adding/deleting, moving) can be made
by right-clicking over the tab and making a choice.

8. Task Bar – Shows open programs.

9. View toolbar – There is now a View toolbar at the bottom right of the screen that lets you choose between Normal,
Page Layout and Page Break Preview -- a view that will show you how your spreadsheet will look when it prints. To
the right of the view toolbar is a slider that lets you zoom in or out of your document.

10. Scroll Bars – Allows you to view entire workbook by moving it up, down (vertical scroll bar), left or right
(horizontal scroll bar).
Parts of the Excel 2007 Screen

11. Screen Split Button – At the top of the vertical scroll bar is a new button. Just below the double arrow is a
tiny button that looks like a minus sign that lets you split your screen in two when double-clicked. Double-
clicking it a second time will unsplit your screen.

12. Group – Command buttons with a common purpose are clustered together. Each ribbon contains several groups.
Some groups, but not all, contain a quick launch bar (dialog box launcher) in the bottom right hand corner.

13. Title Bar – Shows name of program and open workbook. Also contains minimize, maximize and close buttons.
14. Quick Launch Bar/Dialog Box Launcher – It is the arrow in the bottom right hand corner of some groups.
When clicked, it will bring up a dialog box where additional options/changes can be entered.

15. Formula Bar – Shows you exactly what has been typed in the cell. Formatting (e.g., bold, font style)
changes will not show in the formula bar. At the top of the scroll bar is a new button. When you click on
the double arrow button the formula bar area expands for the current cell.

16. Quick Access Toolbar – This customizable toolbar allows you to add frequently used commands. Click on the
down arrow at the end of the toolbar to add/remove command buttons – or - right-click on any command button and
choose Add to Quick Access Toolbar.

17. Tab – The ribbon is broken down into 7 tabs. Each tab has a common purpose and consists of several groups. To
select a tab, simply click on it and the appropriate groups will be displayed.
Parts of the Excel 2007 Screen

17 16 13
1

3
11
14 12

4 15

5
6

10

8
7 9

You might also like