Microsoft Office Excel 2007 Ch. 1 Vocabulary

Created by redsox3410 

Upgrade to
remove ads

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

Workbook

created when Excel starts; like a notebook

Worksheet

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

Cell

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

Gridlines

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

Ready

Excel is ready to accept the next command or data entry

Enter

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

Ribbon

located near the top of the Excel window; the contral center in Excel

Tab

surrounds a collection of groups

Group

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

Gallery

a set of choices, often graphical, arranged in a grid or in a list

In-Ribbon

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

ScreenTip

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

Menu

contains a list of commands

Submenu

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

Text

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

Left-Aligned

the cell entry is positioned at the far left in the cell

Number

represents an amount

AutoCorrect Feature

works behind the scenes, correcting common mistakes when you complete a text entry in a cell

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set