EXCEL - Chapter 5

Created by DesWilkins 

Upgrade to
remove ads

vocabulary

Active cell

The cell displayed with a bold border. Also called the selected cell.

Adjacent cells

Cells that are next to each other.

Borders

Used to format cell borders. Found on the Home tab.

Boundary

The bar separating the column letters at the top of the worksheet.

Cell

The intersection of a row and column.

Cell reference

The column letter and row number that identify a cell, such as B3.

Cell styles

Used to apply several formats in one step.

Circular reference

An error that occurs when a formula references the cell it is stored in.

Columns

Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.

Conditional formatting

Formatting that is applied to a cell when a specified condition is met.

Destination

The upper-left cell of the range where data is to be pasted.

Display formulas

To display formulas in the worksheet, press Ctrl + ` or Formulas - Show Formulas

Duplicate data

To make a copy of data and then place that copy at a different location in the worksheet or into a completely different document.

Fill handle

The solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell to adjacent cells.

Format Painter

Copies cell formatting from one cell to another. Found on the Home tab.

Formula

Mathematical statement used to calculate a value. A formula must always begin with an equal sign.

Formula bar

Displays the active cell's contents. Located above the cells.

Gridlines

Solid lines that mark off the rows and columns in a worksheet.

Headings

Row numbers and column letters.

Label

Text stored in a cell that cannot be used in calculations.

Move data

Delete data from a worksheet and then place that data at a different location in the workbook or into another file.

Name box

Displays the cell reference of the active cell. Located at the top of the worksheet.

Orientation

Used to change text orientation. Found on the Home tab.

Pointing

Clicking a cell to place its reference in a formula.

Range

Selection of two or more cells.

Relative cell reference

A cell reference that reflects the row or column it has been copied to.

Row

Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576.

Selected cell

Indicated by a heavy black border around the cell; also called the active cell.

Sheet tab

Used to display a worksheet.

Source

Selected cells to be copied or moved.

Spreadsheet

An application used to store and analyze data.

Template

A master workbook that includes the basic elements for a particular type of workbook.

Value

Numeric data that can be used in calculations.

Workbook

An Excel file. It contains 3 worksheets by default but can have more added.

Worksheet

Sheets in an Excel workbook.

Wrap Text

Allows for more than one line of text within a cell. Found on the Home tab.

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