52 terms

Microsoft Office Excel 2007 Ch. 1 Vocabulary

Microsoft Office Excel 2007
a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites
Requirements Document
includes a needs statement, source of data, summary of calculations, and any orher special requirements for the worksheetm such as charting and Web support
created when Excel starts; like a notebook
sheets inside a workbook
Column Heading
a column letter above the grid; identifies each column
Row Heading
a row number on the left side of the grid; identifies each row
the basic unit of a worksheet into which you enter data
Cell Reference
the uniaue addresses which a cell is referred by; the coordinates of the intersection of a column and row
Active Cell
the one cell on a worksheet in which you enter data
the horizontal and certical lines on the worksheet itself; make it easier to see and identify each cell in a worksheet
Worksheet Window
you view the portion of the worksheet displayed on the screen through this
Normal View
the default (present) view
Scroll Bars, Scroll Arrows, Scroll Boxes
located below and to the right of the worksheet window; you can use these to move the worksheet window around to view different parts of the active worksheet
Tab Split Box
can be dragged to increase or decrease the view of the sheet tabs
Status Bar
presents information about the worksheet, the function of the button on the mouse pointer is pointing to, or the mode of Excel
Mode Indicators
such as Enter and Ready, appear on the status bar and specify the current mode of Excel
Excel is ready to accept the next command or data entry
Excel is in the process of accepting data through the keyboard into the active cell
Keyboard Indicators
such as scroll lock, show which toggle keys are engaged; appear to the right of the mode indicator
located near the top of the Excel window; the contral center in Excel
surrounds a collection of groups
contains related commands
Home Tab
also called the primary tab; contains groups with more frequently used commands
Active Tab
the tab currently displayed
Contextual Tabs
used to perform certain tasks or work with objects such as charts or tables
Ribbon Commands
include buttons, boxes (text boxes, check boxes, etc.), and galleries
a set of choices, often graphical, arranged in a grid or in a list
shows common gallery choices ont he Ribbon rather than in a dropdown list
Live Preview
a feature that allows you to point to a gallery choice and see its effect in the workseet without actually selecting the choice
Enhanced Screen Tip
an on-screen note that provides the name of the command, available shortcut(s), a description of the command, and sometimes instructions for how to obtain Help about the command
displays only the name and the command
Dialog Box Launcher
when clicked, displays a dialog box or task pane
Dialog Box
contains additional commands and options for the group
Task Pane
a window that contains additional commands and can stay open and visible while you work on the worksheet
Formula Bar
appears below the Ribbon; as you type, Excel displays the entry here
Name Box
where the active cell reference is displayed; located on the left side of the formula toolbar
Mini Toolbar
appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet
Shortcut Menu
appears when you right-click an objectl a list of frequently used commands that relate to the right-clicked object
Quick Access Toolbar
located by default above the Ribbon, provides easy access to frequently used commands
Key Tip Badge
also known as the keyboard code icon; can be used by pressing the ALT key
Key Tip
a commands displayed code letter; using the keyboard, not the mouse
Office Button
a central location for managing and sharing workbooks
contains a list of commands
a list of additional commands associated with the selected command
To Select A Cell
(make it active), use the mouse to move the block plus sign mouse pointer to the cell then click
used to place titles, such as worksheet titles, column titles, and row titles, on the worksheet
Enter Box
if clicked, completes the entry
Cancel Box
if clicked, cancels an entry
Insertion Point
a blinking vertical line that indicated where the next typed character will appear
the cell entry is positioned at the far left in the cell
represents an amount
AutoCorrect Feature
works behind the scenes, correcting common mistakes when you complete a text entry in a cell